* Hand Corrections of duplicates
* if individual ran twice in one year, keep earlier election
* if individual ran twice in one election, keep election with higher margin
* if individual ran twice in one election and margin isn't computed, pick one (1) elected or (2) if not elected, higher vote share
* keep individuals with the same first/last name, who seem distinct, even if in same county

if $year==1995 {
	replace todrop=1 if LAST==	"CABRERA"	& FIRST==	"ALFONSO"	& BALDESIG==	"Retired Administrator"	& place==	"COMPTON UNIFIED"	& rank==	8
	replace todrop=1 if LAST==	"DILLONKNUTSON"	& FIRST==	"CAROLE"	& BALDESIG==	"Businesswoman/College Trustee"	& place==	"NOVATO"	& rank==	1
	replace todrop=1 if LAST==	"GOODIN"	& FIRST==	"WALTER"	& BALDESIG==	"Paralegal"	& place==	"COMPTON UNIFIED"	& rank==	7
	replace todrop=1 if LAST==	"HUBBARD"	& FIRST==	"CHARLES"	& BALDESIG==	"Medical-Legal Administrator"	& place==	"PALM SPRINGS"	& rank==	9
	replace todrop=1 if LAST==	"MEYERS"	& FIRST==	"GAIL"	& BALDESIG==	"Retired"	& place==	"NOVATO"	& rank==	7
	replace todrop=1 if LAST==	"WEAR"	& FIRST==	"BYRON"	& BALDESIG==	"Small Businessman/Community Leader"	& place==	"SAN DIEGO"	& rank==	1 & office=="CITY COUNCIL" & voteshare==1						
}			

if $year==1996 {
	replace todrop=1 if LAST==	"ARMENDARIZ"	& FIRST==	"ART"	& BALDESIG==	"Incumbent"	& place==	"DELANO"	& rank==	1
	replace todrop=1 if LAST==	"BELL"	& FIRST==	"WILLIAM"	& BALDESIG==	"Newspaper Editor"	& place==	"MADERA"	& rank==	2 & elected==3
	replace todrop=1 if LAST==	"BILLS"	& FIRST==	"DON"	& BALDESIG==	"Retired Truck Driver"	& place==	"WHEATLAND"	& rank==	4
	replace todrop=1 if LAST==	"CARTMILL"	& FIRST==	"JAMES"	& BALDESIG==	"Chief Operating Officer"	& place==	"CHULA VISTA"	& rank==	2
	replace todrop=1 if LAST==	"CRAIK"	& FIRST==	"CAMERON"	& BALDESIG==	"General Contractor"	& place==	"ALPINE COUNTY UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"DYZYNSKE"	& FIRST==	"FRED"	& BALDESIG==	"Retired Businessman"	& place==	"PORTOLA"	& rank==	3
	replace todrop=1 if LAST==	"EMFINGER"	& FIRST==	"DIANNA"	& BALDESIG==	"Supervisor/Restaurant"	& place==	"MARICOPA"	& rank==	2
	replace todrop=1 if LAST==	"FLORES"	& FIRST==	"WAYNE"	& BALDESIG==	"Educator/Peace Officer"	& place==	"MANTECA"	& rank==	5
	replace todrop=1 if LAST==	"FLOREZ"	& FIRST==	"GRACE"	& BALDESIG==	"Incumbent"	& place==	"SANTA BARBARA & SNTA. BARB. HIGH"	& rank==	4
	replace todrop=1 if LAST==	"GELMAN"	& FIRST==	"RUTH"	& BALDESIG==	"Investor/Homemaker/Writer"	& place==	"KERN COMMUNITY COLLEGE"	& rank==	3
	replace todrop=1 if LAST==	"GIECK"	& FIRST==	"BOB"	& BALDESIG==	"No ballot designation"	& place==	"ROCKLIN"	& rank==	8
	replace todrop=1 if LAST==	"GLESS"	& FIRST==	"RONALD"	& BALDESIG==	"Electronic Technician"	& place==	"MARYSVILLE"	& rank==	4
	replace todrop=1 if LAST==	"HARTFORDDEROOS"	& FIRST==	"BETH"	& BALDESIG==	"Writer/Educational Researcher"	& place==	"TRACY UNIFIED"	& rank==	15
	replace todrop=1 if LAST==	"HOWERTON"	& FIRST==	"JOYCE"	& BALDESIG==	"Mayor/Business Owner"	& place==	"LOMPC"	& rank==	1
	replace todrop=1 if LAST==	"HUME"	& FIRST==	"SNOW"	& BALDESIG==	"Certified Public Accountant"	& place==	"FULLERTON"	& rank==	7
	replace todrop=1 if LAST==	"KNEPPER"	& FIRST==	"DALE"	& BALDESIG==	"Board President/Businessman"	& place==	"FRESNO COUNTY BOARD OF EDUCATION"	& rank==	2
	replace todrop=1 if LAST==	"LAMADRID"	& FIRST==	"THOMAS"	& BALDESIG==	"County Equipment Operator"	& place==	"LAKESIDE UNION"	& rank==	3
	replace todrop=1 if LAST==	"LOGOLUSO"	& FIRST==	"PATTY"	& BALDESIG==	"Businesswoman"	& place==	"MADERA"	& rank==	1
	replace todrop=1 if LAST==	"LOWE"	& FIRST==	"DORIS"	& BALDESIG==	"Retired Union Administrator"	& place==	"SISKIYOU"	& rank==	2
	replace todrop=1 if LAST==	"MARCANTONIO"	& FIRST==	"JOSEPH"	& BALDESIG==	"Incumbent"	& place==	"SIERRA PLUMAS JOINT UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"MARIOTTI"	& FIRST==	"GRETCHEN"	& BALDESIG==	"Business Woman/Nurse"	& place==	"PINOLE"	& rank==	3
	replace todrop=1 if LAST==	"MARSHALL"	& FIRST==	"LAURA"	& BALDESIG==	"Assessment Clerk"	& place==	"SIERRA-PLUMAS UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"MCCANN"	& FIRST==	"FRANK"	& BALDESIG==	"Landscape Maintenance Businessman"	& place==	"ANTIOCH"	& rank==	5
	replace todrop=1 if LAST==	"MILLSAPS"	& FIRST==	"CLINTON"	& BALDESIG==	"No ballot designation"	& place==	"WILLOWS"	& rank==	5
	replace todrop=1 if LAST==	"MOOT"	& FIRST==	"JOHN"	& BALDESIG==	"Appointed Deputy Mayor"	& place==	"CHULA VISTA"	& rank==	1
	replace todrop=1 if LAST==	"MOTELL"	& FIRST==	"LISA"	& BALDESIG==	"No ballot designation"	& place==	"MARYSVILLE"	& rank==	6
	replace todrop=1 if LAST==	"PELLATZ"	& FIRST==	"CARL"	& BALDESIG==	"Insurance Agent/Broker"	& place==	"HUMBOLDT"	& rank==	3
	replace todrop=1 if LAST==	"PETERS"	& FIRST==	"LINDY"	& BALDESIG==	"Councilmember/Radio Announcer"	& place==	"MENDOCINO"	& rank==	3
	replace todrop=1 if LAST==	"PICO"	& FIRST==	"THOMAS"	& BALDESIG==	"Cert. Public Accountant/Inc. Councilmbr."	& place==	"PLEASANTON"	& rank==	1
	replace todrop=1 if LAST==	"REYNOLDS"	& FIRST==	"JOHN"	& BALDESIG==	"Incumbent"	& place==	"COARSEGOLD ELEMENTARY"	& rank==	1
	replace todrop=1 if LAST==	"ROUDEBUSH"	& FIRST==	"FRAN"	& BALDESIG==	"Incumbent"	& place==	"FEATHER RIVER COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"SANCHEZ"	& FIRST==	"GONZALO"	& BALDESIG==	"Retired Border Patrol"	& place==	"CALEXICO UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"SANTOYA"	& FIRST==	"JOHN"	& BALDESIG==	"President/Taxwatchers Association"	& place==	"FRESNO UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"SCRIBNER"	& FIRST==	"JOHN"	& BALDESIG==	"Trustee/County Board of Education"	& place==	"SAN JOAQUIN COUNTY BOARD OF EDUCATION"	& rank==	2
	replace todrop=1 if LAST==	"SILVA"	& FIRST==	"JOHN"	& BALDESIG==	"Council Member"	& place==	"SISKIYOU"	& rank==	1
	replace todrop=1 if LAST==	"SPATE"	& FIRST==	"KATHRYN"	& BALDESIG==	"Self Employed"	& place==	"CARUTHERS UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"SUDARIO"	& FIRST==	"ANGEL"	& BALDESIG==	"Senior Pharmacy Analyst"	& place==	"ANTIOCH"	& rank==	2
	replace todrop=1 if LAST==	"VANCE"	& FIRST==	"ERNEST"	& BALDESIG==	"Retired College Administrator"	& place==	"LOS RIOS COMMUNITY COLLEGE"	& rank==	4
	replace todrop=1 if LAST==	"VANCE"	& FIRST==	"ERNEST"	& BALDESIG==	"Retired College Administrator"	& place==	"SACRAMENTO COUNTY BOARD OF EDUCATION"	& rank==	2
	replace todrop=1 if LAST==	"VANG"	& FIRST==	"CHARLES"	& BALDESIG==	"Executive Broadcaster"	& place==	"FRESNO COUNTY BOARD OF EDUCATION"	& rank==	4
	replace todrop=1 if LAST==	"WAGNER"	& FIRST==	"RANDY"	& BALDESIG==	"Business Owner"	& place==	"TEHAMA"	& rank==	3
	replace todrop=1 if LAST==	"WALKER"	& FIRST==	"CHARLES"	& BALDESIG==	"Financial Systems Analyst"	& place==	"SCOTTS VALLEY"	& rank==	3
	replace todrop=1 if LAST==	"WHITAKER"	& FIRST==	"BRUCE"	& BALDESIG==	"Business Financial Manager"	& place==	"FULLERTON"	& rank==	5
	replace todrop=1 if LAST==	"WILSON"	& FIRST==	"HELEN"	& BALDESIG==	"Councilmember/Businesswoman"	& place==	"LAKE FOREST"	& rank==	1		
	replace todrop=1 if LAST==	"RICHEIMER"	& FIRST==	"JAMES"	& BALDESIG==	"Business Owner/Analyst"	& place==	"COAST COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"PAVLIK"	& FIRST==	"MICHAEL"	& BALDESIG==	"Incumbent"	& place==	"YREKA UNION HIGH"	& rank==	3	
}

if $year==1997 {
	replace todrop=1 if LAST==	"BURBANK"	& FIRST==	"STEPHEN"	& BALDESIG==	"No ballot designation"	& place==	"KLAMATH-TRINITY JOINT UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"JONES"	& FIRST==	"AUDREY"	& BALDESIG==	"No ballot designation"	& place==	"KLAMATH TRINITY JOINT UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"JONES"	& FIRST==	"AUDREY"	& BALDESIG==	"No ballot designation"	& place==	"KLAMATH-TRINITY JOINT UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"MACDONALD"	& FIRST==	"JAMES"	& BALDESIG==	"Journeyman Auto Mechanic"	& place==	"PITTSBURG UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"MARKUSSEN"	& FIRST==	"MARLENE"	& BALDESIG==	"No ballot designation"	& place==	"KLAMATH TRINITY JOINT UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"VISS"	& FIRST==	"DON"	& BALDESIG==	"Farmer"	& place==	"STANISLAUS COUNTY OFFICE OF EDUCATION"	& rank==	1
}

if $year==1998 {	
	replace todrop=1 if LAST==	"ABBOTT"	& FIRST==	"LANCE"	& BALDESIG==	"Education Reformer/Financial Analyst"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"ANDRONICO"	& FIRST==	"SUSAN"	& BALDESIG==	"Journeyman/Retail Clerk"	& place==	"VACAVILLE"	& rank==	3
	replace todrop=1 if LAST==	"ANGELES"	& FIRST==	"EDDIE"	& BALDESIG==	"Deputy City Attorney"	& place==	"SAN MATEO"	& rank==	2
	replace todrop=1 if LAST==	"BRAUN"	& FIRST==	"SUSAN"	& BALDESIG==	"San Diego Unified School Board Member"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"CASS"	& FIRST==	"GARY"	& BALDESIG==	"CEO/Counselor/Educator"	& place==	"GROSSMONT UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"CHRIST"	& FIRST==	"DELTA"	& BALDESIG==	"Council Member"	& place==	"ETNA"	& rank==	2
	replace todrop=1 if LAST==	"CLARK"	& FIRST==	"DON"	& BALDESIG==	"County Supervisor"	& place==	"PLUMAS"	& rank==	1
	replace todrop=1 if LAST==	"CORONADO"	& FIRST==	"ALEXANDRIA"	& BALDESIG==	"Teacher/Researcher/Businesswoman"	& place==	"ANAHEIM UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"DANIELS"	& FIRST==	"BRET"	& BALDESIG==	"Deputy Sheriff"	& place==	"CITRUS HEIGHTS"	& rank==	3
	replace todrop=1 if LAST==	"DEBECK"	& FIRST==	"JOHN"	& BALDESIG==	"Retired Teacher/Educational Consultant"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"DENNISON"	& FIRST==	"WILLIAM"	& BALDESIG==	"County Supervisor"	& place==	"PLUMAS"	& rank==	1
	replace todrop=1 if LAST==	"DEWITT"	& FIRST==	"DUANE"	& BALDESIG==	"Respiratory Therapist"	& place==	"SANTA ROSA"	& rank==	7
	replace todrop=1 if LAST==	"DRAVES"	& FIRST==	"DENNIS"	& BALDESIG==	"Cable Tech./Pastor"	& place==	"WILLIAMS"	& rank==	4
	replace todrop=1 if LAST==	"DUNCAN"	& FIRST==	"LAWRENCE"	& BALDESIG==	"Computer Technician/Student"	& place==	"PARADISE"	& rank==	8
	replace todrop=1 if LAST==	"FLESHER"	& FIRST==	"DOUG"	& BALDESIG==	"Retired Educator/Businessman"	& place==	"BUTTE-GLENN COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"FLORES"	& FIRST==	"ALICE"	& BALDESIG==	"Teacher/Administrator"	& place==	"SAN BENITO"	& rank==	2
	replace todrop=1 if LAST==	"FORSTER"	& FIRST==	"THOMAS"	& BALDESIG==	"Automotive Recycling"	& place==	"BUTTE COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"HEARD"	& FIRST==	"ROBERT"	& BALDESIG==	"Sheriff/Marshall"	& place==	"TEHAMA"	& rank==	2
	replace todrop=1 if LAST==	"HUDSON"	& FIRST==	"BILL"	& BALDESIG==	"Appointed Incumbent"	& place==	"SAUSALITO ELEMENTARY"	& rank==	3
	replace todrop=1 if LAST==	"HUME"	& FIRST==	"SNOW"	& BALDESIG==	"CPA/Fraud Investigator"	& place==	"FULLERTON"	& rank==	4
	replace todrop=1 if LAST==	"JOE"	& FIRST==	"ALEX"	& BALDESIG==	"Educator"	& place==	"ELK GROVE UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"JOHNSON"	& FIRST==	"GARY"	& BALDESIG==	"Investigator/Peace Officer"	& place==	"PETALUMA"	& rank==	6
	replace todrop=1 if LAST==	"JOHNSTON"	& FIRST==	"ANN"	& BALDESIG==	"Council Member"	& place==	"STOCKTON"	& rank==	1 & month(date)==11
	replace todrop=1 if LAST==	"KOBSEFF"	& FIRST==	"MICHAEL"	& BALDESIG==	"Small Business Owner"	& place==	"SISKIYOU UNION HIGH"	& rank==	3
	replace todrop=1 if LAST==	"LIVERMONT"	& FIRST==	"KIRK"	& BALDESIG==	"Attorney At Law"	& place==	"INYO"	& rank==	2
	replace todrop=1 if LAST==	"MCLAUGHLIN"	& FIRST==	"THOMAS"	& BALDESIG==	"Incumbent"	& place==	"BUTTE COMMUNITY COLLEGE"	& rank==	1
	replace todrop=1 if LAST==	"MCSWEENEY"	& FIRST==	"MICHAEL"	& BALDESIG==	"Business Owner/General Contractor"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"MILLER"	& FIRST==	"JAMES"	& BALDESIG==	"Attorney"	& place==	"GROSSMONT UNION HIGH"	& rank==	6
	replace todrop=1 if LAST==	"MILLER"	& FIRST==	"MARQUIS"	& BALDESIG==	"Flight Instructor/Businessman"	& place==	"SAN LUIS OBISPO OFFICE OF EDUCATIO"	& rank==	1
	replace todrop=1 if LAST==	"MINARICK"	& FIRST==	"JOHNNEY"	& BALDESIG==	"Student and Handyman"	& place==	"GROSSMONT-CUYAMACA COMM. COLL."	& rank==	3
	replace todrop=1 if LAST==	"MOONEY"	& FIRST==	"MARY"	& BALDESIG==	"Auditor/Controller"	& place==	"PLUMAS"	& rank==	1
	replace todrop=1 if LAST==	"MOW"	& FIRST==	"VICTOR"	& BALDESIG==	"Scientist/Council Member"	& place==	"STOCKTON"	& rank==	1
	replace todrop=1 if LAST==	"MUNN"	& FIRST==	"BRUCE"	& BALDESIG==	"General Manager"	& place==	"MADERA"	& rank==	4
	replace todrop=1 if LAST==	"PARKER"	& FIRST==	"CLAY"	& BALDESIG==	"Police Officer"	& place==	"TEHAMA"	& rank==	1 & month(date)==6
	replace todrop=1 if LAST==	"PATTERSON"	& FIRST==	"BILL"	& BALDESIG==	"Small Business Owner"	& place==	"WINDSOR"	& rank==	4
	replace todrop=1 if LAST==	"PERDUE"	& FIRST==	"THOMAS"	& BALDESIG==	"Businessman"	& place==	"PLUMAS"	& rank==	3
	replace todrop=1 if LAST==	"RIDDLESPRIGGER"	& FIRST==	"BILL"	& BALDESIG==	"Incumbent"	& place==	"FRESNO UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"RIVERO"	& FIRST==	"JOSEPH"	& BALDESIG==	"Teacher"	& place==	"ATWATER"	& rank==	1
	replace todrop=1 if LAST==	"SANDOVAL"	& FIRST==	"GREG"	& BALDESIG==	"Board of Trustees/Sweetwater Union High School District"	& place==	"SWEETWATER UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"SIRI"	& FIRST==	"DIANE"	& BALDESIG==	"County Sup. of Schools"	& place==	"SANTA CRUZ"	& rank==	1
	replace todrop=1 if LAST==	"STOWELL"	& FIRST==	"CRAIG"	& BALDESIG==	"Business Owner"	& place==	"EL TEJON UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"TASSONE"	& FIRST==	"GERARD"	& BALDESIG==	"Incumbent"	& place==	"GRASS VALLEY"	& rank==	1
	replace todrop=1 if LAST==	"WAGNER"	& FIRST==	"DONALD"	& BALDESIG==	"O.C. Businessman/Educator"	& place==	"S. ORANGE COUNTY COMM. COLLEGE"	& rank==	1
	replace todrop=1 if LAST==	"WALL"	& FIRST==	"DAVID"	& BALDESIG==	"No ballot designation"	& place==	"SAN JOSE UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"WALLER"	& FIRST==	"RAY"	& BALDESIG==	"Council Member"	& place==	"ETNA"	& rank==	1
	replace todrop=1 if LAST==	"WALTERS"	& FIRST==	"JEAN"	& BALDESIG==	"Businesswoman"	& place==	"PLUMAS"	& rank==	2
	replace todrop=1 if LAST==	"WELLS"	& FIRST==	"JUDITH"	& BALDESIG==	"Clerk/Recorder"	& place==	"PLUMAS"	& rank==	1
	replace todrop=1 if LAST==	"WILLIAMS"	& FIRST==	"ELIZABETH"	& BALDESIG==	"Council Member"	& place==	"GONZALES"	& rank==	4
	
	replace todrop=1 if LAST=="STANTON" & FIRST=="JAMES" & BALDESIG=="Incumbent" & place=="CARLSBAD"
}

if $year==1999 {
	replace todrop=1 if LAST==	"AYRES"	& FIRST==	"JAMES"	& BALDESIG==	"Economic Development Specialist"	& place==	"SAN JACINTO-RECALL"	& rank==	1
	replace todrop=1 if LAST==	"BIGGINS"	& FIRST==	"SALLY"	& BALDESIG==	"Educator"	& place==	"REDWOODS COMMUNITY COLLEGE"	& rank==	2 & CNTYNAME=="TRINITY"
	replace todrop=1 if LAST==	"GREENJORDAN"	& FIRST==	"VIRNIECIA"	& BALDESIG==	"Educator"	& place==	"PERRIS"	& rank==	4
	replace todrop=1 if LAST==	"MCNAIR"	& FIRST==	"MILDRED"	& BALDESIG==	"Educator/Business Woman"	& place==	"EL CAMINO COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"REDENIUS"	& FIRST==	"MARK"	& BALDESIG==	"U.S. Postal Worker"	& place==	"BLACK BUTTE UNION ELEMENTARY"	& rank==	2
}

if $year==2000 {
	replace todrop=1 if LAST==	"APODACA"	& FIRST==	"JENNY"	& BALDESIG==	"Health Care Unionist"	& place==	"PACIFICA"	& rank==	6
	replace todrop=1 if LAST==	"ARANDA"	& FIRST==	"JUAN"	& BALDESIG==	"Governing Board Member/Whisman School Dist"	& place==	"MOUNTAIN VIEW ELEMENTARY/ WHISMAN ELEMENTARY-P"	& rank==	3
	replace todrop=1 if LAST==	"BREAZEAL"	& FIRST==	"MARK"	& BALDESIG==	"Management Consultant"	& place==	"DUBLIN SAN RAMON CSD"	& rank==	10
	replace todrop=1 if LAST==	"BUSBY"	& FIRST==	"JAMES"	& BALDESIG==	"Businessman"	& place==	"VICTORVILLE"	& rank==	4
	replace todrop=1 if LAST==	"COLENZO"	& FIRST==	"ROBERT"	& BALDESIG==	"Local Business Owner"	& place==	"EL DORADO HILLS CSD"	& rank==	5
	replace todrop=1 if LAST==	"DICKEY"	& FIRST==	"DAVID"	& BALDESIG==	"Self-Employed Businessman"	& place==	"UKIAH"	& rank==	3
	replace todrop=1 if LAST==	"DODSON"	& FIRST==	"MARION"	& BALDESIG==	"Solana Beach City Councilmember"	& place==	"SOLANA BEACH"	& rank==	4
	replace todrop=1 if LAST==	"EVANS"	& FIRST==	"NOREEN"	& BALDESIG==	"Councilwoman/Businesswoman/Mother"	& place==	"SANTA ROSA"	& rank==	2
	replace todrop=1 if LAST==	"FISHER"	& FIRST==	"CAROL"	& BALDESIG==	"Governing Board Member/Mountain View SD"	& place==	"MOUNTAIN VIEW ELEMENTARY/ WHISMAN ELEMENTARY-P"	& rank==	1
	replace todrop=1 if LAST==	"FRITCHEN"	& FIRST==	"DALE"	& BALDESIG==	"Chief/Child Protection"	& place==	"MANTECA UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"GARCIA"	& FIRST==	"EDWARD"	& BALDESIG==	"Defense Worker"	& place==	"STOCKTON CITY UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"JONES"	& FIRST==	"OWEN"	& BALDESIG==	"Incumbent"	& place==	"ALBANY CITY UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"JUKUSKY"	& FIRST==	"PETER"	& BALDESIG==	"Executive Director"	& place==	"WILLIAMS"	& rank==	2
	replace todrop=1 if LAST==	"KERN"	& FIRST==	"DAVID"	& BALDESIG==	"Air Traffic Controller"	& place==	"SACRAMENTO CITY UNIFIED"	& rank==	5
	replace todrop=1 if LAST==	"KIDD"	& FIRST==	"QUINTIN"	& BALDESIG==	"Mayor/City of Brentwood"	& place==	"BRENTWOOD"	& rank==	2
	replace todrop=1 if LAST==	"KRUSS"	& FIRST==	"FRANCES"	& BALDESIG==	"Registered Nurse"	& place==	"MOUNTAIN VIEW ELEMENTARY/ WHISMAN ELEMENTARY-P"	& rank==	4
	replace todrop=1 if LAST==	"LISHMAN"	& FIRST==	"KATHI"	& BALDESIG==	"Teacher/City Councilmember"	& place==	"PLACERVILLE"	& rank==	1
	replace todrop=1 if LAST==	"MELENDEZ"	& FIRST==	"GEORGE"	& BALDESIG==	"Retired Educator"	& place==	"SAN JOSE-EVERGREEN COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"MORENO"	& FIRST==	"JOSE"	& BALDESIG==	"Account Representative"	& place==	"RANCHO SANTIAGO COMMUNITY COLLEGE"	& rank==	3
	replace todrop=1 if LAST==	"REESE"	& FIRST==	"RICK"	& BALDESIG==	"Structural Engineer"	& place==	"LA MESA"	& rank==	4
	replace todrop=1 if LAST==	"SCANNELL"	& FIRST==	"DANIEL"	& BALDESIG==	"Public Interest Advocate"	& place==	"DUBLIN SAN RAMON CSD"	& rank==	4
	replace todrop=1 if LAST==	"WALKUP"	& FIRST==	"DEBORAH"	& BALDESIG==	"Consultant"	& place==	"MOUNTAIN VIEW ELEMENTARY/ WHISMAN ELEMENTARY-P"	& rank==	7
	replace todrop=1 if LAST==	"WHITE"	& FIRST==	"MICHAEL"	& BALDESIG==	"Businessman"	& place==	"WASCO"	& rank==	4
	replace todrop=1 if LAST==	"WILLIAMS"	& FIRST==	"GEORGE"	& BALDESIG==	"Consultant/City Council"	& place==	"AUBURN"	& rank==	1
	replace todrop=1 if LAST==	"WILSON"	& FIRST==	"ROBERT"	& BALDESIG==	"Systems Analyst"	& place==	"COLTON"	& rank==	2
}

if $year==2001 {
	replace todrop=1 if LAST==	"ANDREWS"	& FIRST==	"MELANIE"	& BALDESIG==	"College Board member/Educator"	& place==	"COMPTON"	& rank==	2
	replace todrop=1 if LAST==	"DENNEY"	& FIRST==	"VIRGINIA"	& BALDESIG==	"Incumbent"	& place==	"VAL VERDE UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"GARCIA"	& FIRST==	"EVARISTO"	& BALDESIG==	"Sports Organizer"	& place==	"COMPTON COMMUNITY COLLEGE"	& rank==	4
	replace todrop=1 if LAST==	"GEORGE"	& FIRST==	"GARY"	& BALDESIG==	"Appointed Governing Board Member"	& place==	"CHAFFEY COMMUNITY COLLEGE"	& rank==	1
	replace todrop=1 if LAST==	"KIMBREW"	& FIRST==	"BASIL"	& BALDESIG==	"School Board Member"	& place==	"COMPTON UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"LANKSTER"	& FIRST==	"SAUL"	& BALDESIG==	"State University Professor"	& place==	"COMPTON"	& rank==	6
	replace todrop=1 if LAST==	"LEWIS"	& FIRST==	"JOSEPH"	& BALDESIG==	"Child Development Educator"	& place==	"COMPTON UNIFIED"	& rank==	17
	replace todrop=1 if LAST==	"MORA"	& FIRST==	"JUAN"	& BALDESIG==	"Locomotive Engineer"	& place==	"COMPTON UNIFIED"	& rank==	14
	replace todrop=1 if LAST==	"PHELPS"	& FIRST==	"JEROLD"	& BALDESIG==	"Incumbent"	& place==	"REDWOODS COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"RIOS"	& FIRST==	"EVA"	& BALDESIG==	"Incumbent"	& place==	"GONZALES UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"ROBINSON"	& FIRST==	"CARL"	& BALDESIG==	"Certified Contract Recruiter"	& place==	"COMPTON UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"RODRIGUEZ"	& FIRST==	"RAMON"	& BALDESIG==	"Business Development Manager"	& place==	"CARSON UNIFIED- PROPOSED"	& rank==	15
	replace todrop=1 if LAST==	"SHARIF"	& FIRST==	"EMMA"	& BALDESIG==	"Youth Development Coordinator"	& place==	"COMPTON UNIFIED"	& rank==	7
	replace todrop=1 if LAST==	"SWANSON"	& FIRST==	"JUDY"	& BALDESIG==	"Homemaker"	& place==	"LANCASTER ELEMENTARY"	& rank==	5
	replace todrop=1 if LAST==	"TRUETT"	& FIRST==	"GEORGE"	& BALDESIG==	"Editor"	& place==	"REDWOOD COMMUNITY COLLEGE"	& rank==	1
}

if $year==2002 {
	replace todrop=1 if LAST==	"ARAFILES"	& FIRST==	"FELICIA"	& BALDESIG==	"Self-Employed/Businesswoman"	& place==	"STOCKTON"	& rank==	2
	replace todrop=1 if LAST==	"AVILA"	& FIRST==	"PAUL"	& BALDESIG==	"Retired State Counselor"	& place==	"ONTARIO"	& rank==	6
	replace todrop=1 if LAST==	"BAKEER"	& FIRST==	"EMAD"	& BALDESIG==	"Counselor"	& place==	"CAJON VALLEY UNION ELEMENTARY"	& rank==	7
	replace todrop=1 if LAST==	"BENIGNO"	& FIRST==	"GREGORY"	& BALDESIG==	"Business Owner/Agent"	& place==	"STOCKTON"	& rank==	2
	replace todrop=1 if LAST==	"BESTOLARIDES"	& FIRST==	"STEVE"	& BALDESIG==	"Business Person/Banker"	& place==	"STOCKTON"	& rank==	1
	replace todrop=1 if LAST==	"BILLS"	& FIRST==	"HARVEY"	& BALDESIG==	"School Teacher"	& place==	"STOCKTON"	& rank==	2
	replace todrop=1 if LAST==	"BLOWERS"	& FIRST==	"MELODIE"	& BALDESIG==	"School Board Trustee"	& place==	"LINCOLN UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"BUNTHOFF"	& FIRST==	"THOMAS"	& BALDESIG==	"No ballot designation"	& place==	"DOS PALOS"	& rank==	2
	replace todrop=1 if LAST==	"CORNELL"	& FIRST==	"MICHAEL"	& BALDESIG==	"Businessman"	& place==	"EL CAJON"	& rank==	4
	replace todrop=1 if LAST==	"CROW"	& FIRST==	"VICKY"	& BALDESIG==	"Certified Public Accountant"	& place==	"FRESNO"	& rank==	1
	replace todrop=1 if LAST==	"DANIELS"	& FIRST==	"BRET"	& BALDESIG==	"Councilman/City of Citrus Heights"	& place==	"CITRUS HEIGHTS"	& rank==	3
	replace todrop=1 if LAST==	"DAYSOG"	& FIRST==	"TONY"	& BALDESIG==	"Alameda City Councilmember"	& place==	"ALAMEDA"	& rank==	1
	replace todrop=1 if LAST==	"DICTOS"	& FIRST==	"PAUL"	& BALDESIG==	"CPA/Auditor/Controller"	& place==	"FRESNO"	& rank==	2
	replace todrop=1 if LAST==	"FLICKINGER"	& FIRST==	"BONNIE"	& BALDESIG==	"City Councilmember"	& place==	"MORENO VALLEY"	& rank==	1
	replace todrop=1 if LAST==	"GARZA"	& FIRST==	"OSCAR"	& BALDESIG==	"Library Commissioner/Educator"	& place==	"SANTA ANA UNIFIED"	& rank==	5
	replace todrop=1 if LAST==	"GIOVANETTI"	& FIRST==	"GARY"	& BALDESIG==	"Incumbent"	& place==	"STOCKTON"	& rank==	1
	replace todrop=1 if LAST==	"GOMEZ"	& FIRST==	"RAMON"	& BALDESIG==	"Paralegal/Council Member"	& place==	"WATSONVILLE"	& rank==	1
	replace todrop=1 if LAST==	"HOFFMAN"	& FIRST==	"RANDY"	& BALDESIG==	"Planning Commissioner/Businessman"	& place==	"THOUSAND OAKS"	& rank==	2
	replace todrop=1 if LAST==	"HOHMAN"	& FIRST==	"THOMAS"	& BALDESIG==	"Businessman and Parent"	& place==	"SAN DIEGUITO UNION HIGH"	& rank==	4
	replace todrop=1 if LAST==	"KENNEDY"	& FIRST==	"DENNIS"	& BALDESIG==	"Mayor"	& place==	"MORGAN HILL"	& rank==	1
	replace todrop=1 if LAST==	"LANE"	& FIRST==	"JOHN"	& BALDESIG==	"Chief Investigator/Educator"	& place==	"VENTURA COUNTY OFFICE OF EDUCATION"	& rank==	2
	replace todrop=1 if LAST==	"LARSON"	& FIRST==	"PHIL"	& BALDESIG==	"Farmer/Businessman"	& place==	"FRESNO"	& rank==	1 & term=="Full"
	replace todrop=1 if LAST==	"LEMARIE"	& FIRST==	"LAUREL"	& BALDESIG==	"Parent/Homemaker"	& place==	"RANCHO SANTA FE ELEMENTARY"	& rank==	6
	replace todrop=1 if LAST==	"MARTIN"	& FIRST==	"LESLIE"	& BALDESIG==	"Appointed Councilmember"	& place==	"STOCKTON"	& rank==	1
	replace todrop=1 if LAST==	"MARTINEZROACH"	& FIRST==	"PATRICIA"	& BALDESIG==	"Schoolteacher/Mother/Consultant"	& place==	"EAST SIDE UNION HIGH"	& rank==	3
	replace todrop=1 if LAST==	"MITCHELL"	& FIRST==	"SAM"	& BALDESIG==	"Retired"	& place==	"RAMONA UNIFIED"	& rank==	7
	replace todrop=1 if LAST==	"ORTIZ"	& FIRST==	"FRANCIS"	& BALDESIG==	"Incumbent"	& place==	"WOODLAKE"	& rank==	1
	replace todrop=1 if LAST==	"PALLA"	& FIRST==	"JEANETTE"	& BALDESIG==	"Family Law Facilitator"	& place==	"TINITY"	& rank==	2
	replace todrop=1 if LAST==	"PERRY"	& FIRST==	"CARLON"	& BALDESIG==	"Mayor"	& place==	"MANTECA"	& rank==	2
	replace todrop=1 if LAST==	"POWERS"	& FIRST==	"GREGORY"	& BALDESIG==	"Dana Point Businessman"	& place==	"DANA POINT"	& rank==	5
	replace todrop=1 if LAST==	"REED"	& FIRST==	"JAMES"	& BALDESIG==	"Appointed Governing Board Member/Westminster School District"	& place==	"WESTMINSTER ELEMENTARY"	& rank==	1
	replace todrop=1 if LAST==	"RIDDLESPRIGGER"	& FIRST==	"BILL"	& BALDESIG==	"Educator"	& place==	"FRESNO"	& rank==	3
	replace todrop=1 if LAST==	"RODRIGUEZ"	& FIRST==	"TRINIDAD"	& BALDESIG==	"Businessman"	& place==	"KERMAN"	& rank==	1
	replace todrop=1 if LAST==	"RUSH"	& FIRST==	"BRET"	& BALDESIG==	"Administrative Director"	& place==	"FRESNO UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"STIERINGER"	& FIRST==	"JAMES"	& BALDESIG==	"Treasurer/Healthcare District"	& place==	"LA MESA"	& rank==	1
	replace todrop=1 if LAST==	"TWISSELMAN"	& FIRST==	"CARL"	& BALDESIG==	"Rancher"	& place==	"TAFT UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"WOODWARD"	& FIRST==	"JAMES"	& BALDESIG==	"Attorney"	& place==	"TINITY"	& rank==	1
}

if $year==2003 {
	replace todrop=1 if LAST==	"ALMEIDA"	& FIRST==	"RUDY"	& BALDESIG==	"Retired Aerospace Coordinator"	& place==	"HACIENDA LA PUENTE UNIFIED"	& rank==	9
	replace todrop=1 if LAST==	"CHANG"	& FIRST==	"THOMAS"	& BALDESIG==	"Transportation Engineer/Teacher"	& place==	"HACIENDA LA PUENTE UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"EASTER"	& FIRST==	"FRED"	& BALDESIG==	"Retired School Administrator"	& place==	"COMPTON UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"HSU"	& FIRST==	"NORMAN"	& BALDESIG==	"Governing Board Member/Hacienda La Puente Unified School District"	& place==	"HACIENDA LA PUENTE UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"JOHNSON"	& FIRST==	"LORRAINE"	& BALDESIG==	"Councilwoman"	& place==	"INGLEWOOD"	& rank==	2
	replace todrop=1 if LAST==	"SINER"	& FIRST==	"RAY"	& BALDESIG==	"Chef"	& place==	"GATEWAY UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"WEAGEL"	& FIRST==	"DEWAYNE"	& BALDESIG==	"Retired School Employee"	& place==	"DOS PALOS-ORA LOMA JOINT UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"CHYR"	& FIRST==	"FRED"	& BALDESIG==	"Governing Board Member/Mt. San Antonio Community College"	& place==	"MT. SAN ANTONIO COMMUNITY COLLEGE"	& rank==	3	
}

if $year==2004 {
	replace todrop=1 if LAST==	"ADKINS"	& FIRST==	"NANCY"	& BALDESIG==	"Incumbent"	& place==	"LOOMIS UNION ELEMENTARY"	& rank==	1
	replace todrop=1 if LAST==	"BARAJAS"	& FIRST==	"PETRA"	& BALDESIG==	"Retired Realtor/Broker"	& place==	"SWEETWATER UNION HIGH"	& rank==	7
	replace todrop=1 if LAST==	"BILLS"	& FIRST==	"HARVEY"	& BALDESIG==	"Teacher/Retired Military"	& place==	"LODI UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"BRODY"	& FIRST==	"AL"	& BALDESIG==	"Educator/Business Owner"	& place==	"EL DORADO HILLS CSD"	& rank==	5
	replace todrop=1 if LAST==	"BRUNS"	& FIRST==	"WILLIS"	& BALDESIG==	"Business Owner"	& place==	"LAKE"	& rank==	3
	replace todrop=1 if LAST==	"BUSCH"	& FIRST==	"JOHN"	& BALDESIG==	"Businessman"	& place==	"BIGGS"	& rank==	1
	replace todrop=1 if LAST==	"FRANKLIN"	& FIRST==	"BRETT"	& BALDESIG==	"Santa Ana Councilman/Businessman"	& place==	"RANCHO SANTIAGO COMMUNITY COLLEGE"	& rank==	5
	replace todrop=1 if LAST==	"FU"	& FIRST==	"FRANK"	& BALDESIG==	"State Law Enforcement"	& place==	"CHINO HILLS"	& rank==	4
	replace todrop=1 if LAST==	"JACOBI"	& FIRST==	"VERONICA"	& BALDESIG==	"Business Owner/Engineer"	& place==	"SANTA ROSA"	& rank==	5
	replace todrop=1 if LAST==	"JOHNSON"	& FIRST==	"RANDY"	& BALDESIG==	"Incumbent"	& place==	"SCOTTS VALLEY"	& rank==	2
	replace todrop=1 if LAST==	"LILBURN"	& FIRST==	"PENNY"	& BALDESIG==	"Incumbent"	& place==	"HIGHLAND"	& rank==	2
	replace todrop=1 if LAST==	"MARSH"	& FIRST==	"KERMIT"	& BALDESIG==	"Westminster City Councilmember"	& place==	"WESTMINSTER"	& rank==	1
	replace todrop=1 if LAST==	"MENDRIBIL"	& FIRST==	"JOHN"	& BALDESIG==	"Engineer Technician"	& place==	"ROHNERT PARK"	& rank==	9
	replace todrop=1 if LAST==	"MITOMA"	& FIRST==	"MICHAEL"	& BALDESIG==	"Businessman"	& place==	"CARSON"	& rank==	2
	replace todrop=1 if LAST==	"MOZENA"	& FIRST==	"STEVE"	& BALDESIG==	"Educational Materials Businessman"	& place==	"CARSON"	& rank==	10
	replace todrop=1 if LAST==	"PAPPAS"	& FIRST==	"STEVEN"	& BALDESIG==	"Businessman"	& place==	"LOS OLIVOS ELEMENTARY"	& rank==	3
	replace todrop=1 if LAST==	"PEOPLES"	& FIRST==	"JAMES"	& BALDESIG==	"Retired Administrator"	& place==	"CARSON"	& rank==	8
	replace todrop=1 if LAST==	"PRICE"	& FIRST==	"MARK"	& BALDESIG==	"Board Member/Alpine Community Planning Group"	& place==	"SAN DIEGO"	& rank==	1
	replace todrop=1 if LAST==	"RABENALDT"	& FIRST==	"BILL"	& BALDESIG==	"Incumbent"	& place==	"PISMO BEACH"	& rank==	1
	replace todrop=1 if LAST==	"SANDOVAL"	& FIRST==	"MARTIN"	& BALDESIG==	"Account Executive"	& place==	"SAN JOAQUIN"	& rank==	5
	replace todrop=1 if LAST==	"SCOTT"	& FIRST==	"EDWARD"	& BALDESIG==	"Business Owner"	& place==	"RIALTO"	& rank==	1
	replace todrop=1 if LAST==	"URDAHL"	& FIRST==	"LAWRENCE"	& BALDESIG==	"Member/Alpine Community Planning Group"	& place==	"SAN DIEGO"	& rank==	4
	replace todrop=1 if LAST==	"WESTWELL"	& FIRST==	"NORM"	& BALDESIG==	"Huntington Beach Sportswear Manufacturer"	& place==	"HUNTINGTON BEACH"	& rank==	7
	replace todrop=1 if LAST==	"WOOD"	& FIRST==	"RONALD"	& BALDESIG==	"Retired Military/Corrections"	& place==	"LASSEN UNION HIGH"	& rank==	3
	replace todrop=1 if LAST==	"ZARAGOZA"	& FIRST==	"JOHN"	& BALDESIG==	"City Councilmember/Businessman"	& place==	"OXNARD"	& rank==	1		
}

if $year==2005 {
	replace todrop=1 if LAST==	"AVALOS"	& FIRST==	"CARMEN"	& BALDESIG==	"Municipal Clerk/Educator"	& place==	"CERRITOS COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"ESTRADA"	& FIRST==	"JOEL"	& BALDESIG==	"Public Relation Director"	& place==	"COMPTON UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"HUIZAR"	& FIRST==	"JOSE"	& BALDESIG==	"School Boardmember/Attorney"	& place==	"LOS ANGELES"	& rank==	1
	replace todrop=1 if LAST==	"MARLER"	& FIRST==	"GLORIA"	& BALDESIG==	"School Board Trustee"	& place==	"GROVELAND CSD"	& rank==	4
	replace todrop=1 if LAST==	"MCDONALD"	& FIRST==	"DENNIS"	& BALDESIG==	"Retired Fire Chief"	& place==	"ROSEMEAD ELEMENTARY"	& rank==	2
	replace todrop=1 if LAST==	"TYE"	& FIRST==	"STEVE"	& BALDESIG==	"Businessman/Financial Advisor"	& place==	"DIAMOND BAR"	& rank==	1	
}

if $year==2006 {
	replace todrop=1 if LAST==	"AGUILERA"	& FIRST==	"RENE"	& BALDESIG==	"Incumbent"	& place==	"ROSEVILLE CITY ELEMENTARY"	& rank==	3
	replace todrop=1 if LAST==	"ALKHAFAJI"	& FIRST==	"RAFAH"	& BALDESIG==	"Student"	& place==	"LAKESIDE UNION ELEMENTARY"	& rank==	8
	replace todrop=1 if LAST==	"BAKEER"	& FIRST==	"EMAD"	& BALDESIG==	"Board Member/Community Planning Area"	& place==	"GROSSMONT-CUYAMACA COMMUNITY COLLEGE"	& rank==	4
	replace todrop=1 if LAST==	"CARRIZOSA"	& FIRST==	"CHRISTINA"	& BALDESIG==	"Elementary School Teacher"	& place==	"POMONA"	& rank==	1
	replace todrop=1 if LAST==	"DEBECK"	& FIRST==	"JOHN"	& BALDESIG==	"Retired Teacher"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	1 & month(date)==11
	replace todrop=1 if LAST==	"DIAS"	& FIRST==	"SUZANNE"	& BALDESIG==	"Housewife"	& place==	"AMERICAN UNION ELEMENTARY"	& rank==	5
	replace todrop=1 if LAST==	"FERNANDEZ"	& FIRST==	"LETICIA"	& BALDESIG==	"Self-Employed"	& place==	"GOLDEN PLAINS UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"GOMEZ"	& FIRST==	"TIM"	& BALDESIG==	"Parent/Business Owner"	& place==	"SAN YSIDRO ELEMENTARY"	& rank==	6
	replace todrop=1 if LAST==	"GUILLEN"	& FIRST==	"ROBERT"	& BALDESIG==	"Manufacturing Production Manager"	& place==	"RIO ELEMENTARY"	& rank==	1
	replace todrop=1 if LAST==	"GURULE"	& FIRST==	"MANUEL"	& BALDESIG==	"Businessman"	& place==	"BARSTOW"	& rank==	7
	replace todrop=1 if LAST==	"JENKIN"	& FIRST==	"WILLIAM"	& BALDESIG==	"Businessman"	& place==	"RAMONA CITY UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"KHANNA"	& FIRST==	"MOHINDER"	& BALDESIG==	"Retired Senior Manager Waste Water Engg."	& place==	"DUBLIN-SAN RAMON CSD"	& rank==	3
	replace todrop=1 if LAST==	"LAMPHIER"	& FIRST==	"TERRY"	& BALDESIG==	"No ballot designation"	& place==	"GRASS VALLEY"	& rank==	3
	replace todrop=1 if LAST==	"LOWENTHAL"	& FIRST==	"SUJA"	& BALDESIG==	"Member/Board of Education District 3"	& place==	"LONG BEACH UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"MAGUIRE"	& FIRST==	"PAUL"	& BALDESIG==	"Doctor/Businessman"	& place==	"AMERICAN CANYON"	& rank==	2
	replace todrop=1 if LAST==	"MAHAN"	& FIRST==	"PATRICIA"	& BALDESIG==	"Mayor of Santa Clara"	& place==	"SANTA CLARA"	& rank==	1
	replace todrop=1 if LAST==	"MIKELS"	& FIRST==	"MARJORIE"	& BALDESIG==	"Taxpayers' Advocate/Attorney"	& place==	"UPLAND"	& rank==	5
	replace todrop=1 if LAST==	"MILLER"	& FIRST==	"JOHN"	& BALDESIG==	"Deputy Labor Commissioner"	& place==	"AMERICAN CANYON"	& rank==	4 & month(date)==11
	replace todrop=1 if LAST==	"RODRIGUEZ"	& FIRST==	"DANIEL"	& BALDESIG==	"Incumbent"	& place==	"POMONA"	& rank==	2
	replace todrop=1 if LAST==	"RUSSELL"	& FIRST==	"BILL"	& BALDESIG==	"Business Person"	& place==	"AMERICAN CANYON"	& rank==	7
	replace todrop=1 if LAST==	"SANCHEZ"	& FIRST==	"PETE"	& BALDESIG==	"Supervising Auditor-Appraiser"	& place==	"SOLANO"	& rank==	2
	replace todrop=1 if LAST==	"SCHUMSKY"	& FIRST==	"MATT"	& BALDESIG==	"Business Entrepreneur/Realtor"	& place==	"SAN DIEGO"	& rank==	8
	replace todrop=1 if LAST==	"SHAWVER"	& FIRST==	"DAVID"	& BALDESIG==	"Councilman-Teacher-Coach"	& place==	"STANTON"	& rank==	3
	replace todrop=1 if LAST==	"TURNER"	& FIRST==	"ROSS"	& BALDESIG==	"Agriculturist/Business Man"	& place==	"CORNING"	& rank==	2
	replace todrop=1 if LAST==	"TWISSELMAN"	& FIRST==	"CARL"	& BALDESIG==	"Incumbent"	& place==	"TAFT UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"VALLE"	& FIRST==	"RICHARD"	& BALDESIG==	"Councilmember"	& place==	"UNION CITY"	& rank==	2
	replace todrop=1 if LAST==	"WALKER"	& FIRST==	"JAMES"	& BALDESIG==	"Student"	& place==	"AMERICAN CANYON"	& rank==	6 & month(date)==11
	replace todrop=1 if LAST==	"WESTWELL"	& FIRST==	"NORM"	& BALDESIG==	"Huntington Beach Sportswear Manufacturer"	& place==	"HUNTINGTON BEACH"	& rank==	7
	replace todrop=1 if LAST==	"WINET"	& FIRST==	"RICK"	& BALDESIG==	"Member/La Mesa-Spring Valley School District Board"	& place==	"LA MESA-SPRING VALLEY"	& rank==	3
	replace todrop=1 if LAST==	"YOUNG"	& FIRST==	"ARNOLD"	& BALDESIG==	"Incumbent"	& place==	"WEST PATTON VILLAGE"	& rank==	1
	replace todrop=1 if LAST==	"ZSCHIESCHE"	& FIRST==	"PETER"	& BALDESIG==	"Trustee/San Diego Community College District"	& place==	"SAN DIEGO COMMUNITY COLLEGE"	& rank==	1 & month(date)==11
}

if $year==2007 {
	replace todrop=1 if LAST==	"ALEXANDER"	& FIRST==	"WILLIAM"	& BALDESIG==	"No ballot designation"	& place==	"KEYES CSD"	& rank==	4
	*replace todrop=1 if LAST==	"ARRIGHI"	& FIRST==	"DANIEL"	& BALDESIG==	"Water Resources Manager"	& place==	"TEMPLE CITY UNIFIED"	& rank==	5
	replace todrop=1 if LAST==	"BALLAGH"	& FIRST==	"TINA"	& BALDESIG==	"Pastor"	& place==	"ARENA UNION ELEMENTARY/POINT ARENA JOINT UNION HIGH"	& rank==	5
	replace todrop=1 if LAST==	"BALLAGH"	& FIRST==	"WILLIAM"	& BALDESIG==	"Advertising Manager"	& place==	"POINT ARENA JOINT UNION HIGH"	& rank==	7
	replace todrop=1 if LAST==	"BOYD"	& FIRST==	"PETER"	& BALDESIG==	"Business Owner"	& place==	"POINT ARENA JOINT UNION HIGH"	& rank==	6
	replace todrop=1 if LAST==	"CASTRO"	& FIRST==	"AIDE"	& BALDESIG==	"Non-Profit Director/Businesswoman"	& place==	"LYNWOOD"	& rank==	1
	replace todrop=1 if LAST==	"CROCKETT"	& FIRST==	"JOEL"	& BALDESIG==	"Bookstore Owner"	& place==	"ARENA UNION ELEMENTARY/POINT ARENA JOINT UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"DAUGHTON"	& FIRST==	"MADELINE"	& BALDESIG==	"Appointed Incumbent"	& place==	"COVELO CSD"	& rank==	3
	replace todrop=1 if LAST==	"DUKATZ"	& FIRST==	"CHRISTINE"	& BALDESIG==	"Tribal Administrator"	& place==	"POINT ARENA JOINT UNION HIGH"	& rank==	3
	replace todrop=1 if LAST==	"JACINTO"	& FIRST==	"EDWIN"	& BALDESIG==	"Realtor"	& place==	"LYNWOOD"	& rank==	8
	replace todrop=1 if LAST==	"LAW"	& FIRST==	"MAYNARD"	& BALDESIG==	"Retired Educator/Administrator"	& place==	"ABC UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"MARQUEZ"	& FIRST==	"ANGELA"	& BALDESIG==	"Caterer"	& place==	"POINT ARENA JOINT UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"RODRIGUEZ"	& FIRST==	"RAMON"	& BALDESIG==	"Businessman"	& place==	"LYNWOOD"	& rank==	7
	replace todrop=1 if LAST==	"RUSH"	& FIRST==	"SUSAN"	& BALDESIG==	"Family Business Partner"	& place==	"POINT ARENA JOINT UNION HIGH"	& rank==	4
	replace todrop=1 if LAST==	"SANCHEZ"	& FIRST==	"ADAM"	& BALDESIG==	"Planning Commissioner"	& place==	"DESERT HOT SPRINGS"	& rank==	2
	replace todrop=1 if LAST==	"SANDOVAL"	& FIRST==	"SUSAN"	& BALDESIG==	"Appointed Incumbent"	& place==	"ARENA UNION ELEMENTARY/POINT ARENA JOINT UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"SMITH"	& FIRST==	"GORDON"	& BALDESIG==	"Appointed Incumbent"	& place==	"POINT ARENA JOINT UNION HIGH"	& rank==	3	
}

if $year==2008 {
	replace todrop=1 if LAST==	"ALMONTE"	& FIRST==	"HERMY"	& BALDESIG==	"Property Manager/Parent"	& place==	"SAN LEANDRO UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"ALVAREZ"	& FIRST==	"EDDIE"	& BALDESIG==	"Businessman"	& place==	"SANTA ROSA"	& rank==	10
	replace todrop=1 if LAST==	"BARRERA"	& FIRST==	"RICHARD"	& BALDESIG==	"Parent/Community Coordinator"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	1 & month(date)==11
	replace todrop=1 if LAST==	"CHUIDIAN"	& FIRST==	"JUDITH"	& BALDESIG==	"Mother"	& place==	"PLEASANT VALLEY ELEMENTARY"	& rank==	3
	replace todrop=1 if LAST==	"COFFEY"	& FIRST==	"CINDY"	& BALDESIG==	"Vice Mayor/Publisher"	& place==	"AMERICAN CANYON"	& rank==	2
	replace todrop=1 if LAST==	"DOUGLAS"	& FIRST==	"ROBERT"	& BALDESIG==	"Educator"	& place==	"ORANGE"	& rank==	3
	replace todrop=1 if LAST==	"FLORES"	& FIRST==	"ROBERT"	& BALDESIG==	"Business Owner"	& place==	"ANAHEIM"	& rank==	7
	replace todrop=1 if LAST==	"HUFFMAN"	& FIRST==	"ROBIN"	& BALDESIG==	"Social Science Instructor"	& place==	"PARADISE"	& rank==	5
	replace todrop=1 if LAST==	"HUNT"	& FIRST==	"BARBARA"	& BALDESIG==	"Business Woman"	& place==	"FRESNO"	& rank==	8
	replace todrop=1 if LAST==	"LEAL"	& FIRST==	"JUAN"	& BALDESIG==	"Hamilton Elementary Board Member"	& place==	"HAMILTON UNIFIED-P"	& rank==	3
	replace todrop=1 if LAST==	"MADDOX"	& FIRST==	"KENNETH"	& BALDESIG==	"School Board member/Businessman"	& place==	"CAPISTRANO UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"MARTINEZROACH"	& FIRST==	"PATRICIA"	& BALDESIG==	"Schoolteacher/Mother/Consultant"	& place==	"EAST SIDE UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"MATEO"	& FIRST==	"CHRISTOPHER"	& BALDESIG==	"Retired Postal Clerk"	& place==	"LATHROP"	& rank==	2
	replace todrop=1 if LAST==	"MILLER"	& FIRST==	"GARY"	& BALDESIG==	"Retired Teacher"	& place==	"CAPISTRANO UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"OLEARY"	& FIRST==	"DENIS"	& BALDESIG==	"Teacher/School Trustee"	& place==	"VENTURA"	& rank==	3
	replace todrop=1 if LAST==	"OLIVER"	& FIRST==	"ROBERT"	& BALDESIG==	"Councilmember/Retired Minister"	& place==	"LATHROP"	& rank==	3
	replace todrop=1 if LAST==	"OSMUNDSON"	& FIRST==	"KAREN"	& BALDESIG==	"Incumbent"	& place==	"PAJARO VALLEY JOINT UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"PALAZZO"	& FIRST==	"SUSAN"	& BALDESIG==	"Property Manager/Teacher"	& place==	"CAPISTRANO UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"PEREA"	& FIRST==	"HENRY"	& BALDESIG==	"City Council Member"	& place==	"FRESNO"	& rank==	2
	replace todrop=1 if LAST==	"PULICE"	& FIRST==	"DAVID"	& BALDESIG==	"Senior Control Engineer"	& place==	"DUBLIN-SAN RAMON SD"	& rank==	4
	replace todrop=1 if LAST==	"REYES"	& FIRST==	"RUDY"	& BALDESIG==	"Archaeologist/Educator/Scientist"	& place==	"SANTEE"	& rank==	2
	replace todrop=1 if LAST==	"ROCHA"	& FIRST==	"MARY"	& BALDESIG==	"Program Director"	& place==	"ANTIOCH"	& rank==	1
	replace todrop=1 if LAST==	"SIMMONS"	& FIRST==	"GERI"	& BALDESIG==	"Parent/Administrative Secretary"	& place==	"PARAJO VALLEY JOINT UNION"	& rank==	2
	replace todrop=1 if LAST==	"SLERT"	& FIRST==	"CHARLES"	& BALDESIG==	"Architect"	& place==	"CRESENT CITY"	& rank==	1
	replace todrop=1 if LAST==	"SMITH"	& FIRST==	"TIM"	& BALDESIG==	"Councilmember"	& place==	"ROHNERT PARK"	& rank==	5
	replace todrop=1 if LAST==	"SWEARINGEN"	& FIRST==	"ROY"	& BALDESIG==	"Incumbent"	& place==	"PINOLE"	& rank==	2
	replace todrop=1 if LAST==	"TICHY"	& FIRST==	"MARK"	& BALDESIG==	"No ballot designation"	& place==	"SAN LEANDRO UNIFIED"	& rank==	4
	replace todrop=1 if LAST==	"WIESNER"	& FIRST==	"LAWRENCE"	& BALDESIG==	"Accountant/Homeschooler/Parent"	& place==	"SANTA ROSA"	& rank==	4
	replace todrop=1 if LAST==	"WINANT"	& FIRST==	"JERRY"	& BALDESIG==	"School Teacher/Administrator"	& place==	"ORANGE UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"YZAGUIRRE"	& FIRST==	"VINCENT"	& BALDESIG==	"Councilmember District 3"	& place==	"COLTON"	& rank==	1
}

if $year==2009 {
	replace todrop=1 if LAST==	"AVALOS"	& FIRST==	"CARMEN"	& BALDESIG==	"Governing Board Member"	& place==	"CERRITOS COMMUNITY COLLEGE"	& rank==	4
	replace todrop=1 if LAST==	"CLAY"	& FIRST==	"AMOS"	& BALDESIG==	"Appointed Incumbent"	& place==	"COMPTON"	& rank==	1
	replace todrop=1 if LAST==	"ESSEL"	& FIRST==	"CHRISTINE"	& BALDESIG==	"Businesswoman/Neighborhood Advocate"	& place==	"LOS ANGELES"	& rank==	2 & term=="Short"
	replace todrop=1 if LAST==	"HAGGERTY"	& FIRST==	"JUDY"	& BALDESIG==	"Governing Board Member"	& place==	"MT. SAN ANTONIO COMMUNITY COLLEGE"	& rank==	1
	replace todrop=1 if LAST==	"HALL"	& FIRST==	"DAVID"	& BALDESIG==	"Governing Board Member"	& place==	"MOUNT SAN ANTONIO COMMUNITY COLLEGE"	& rank==	3
	replace todrop=1 if LAST==	"HELZER"	& FIRST==	"PAUL"	& BALDESIG==	"Incumbent"	& place==	"BELLFLOWER UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"JONES"	& FIRST==	"WILLIE"	& BALDESIG==	"College Educator"	& place==	"COMPTON"	& rank==	2
	replace todrop=1 if LAST==	"KREKORIAN"	& FIRST==	"PAUL"	& BALDESIG==	"San Fernando Valley Assemble member"	& place==	"LOS ANGELES"	& rank==	1 & elected==3
	replace todrop=1 if LAST==	"MENDOZA"	& FIRST==	"JOHN"	& BALDESIG==	"Water Board Member"	& place==	"MT. SAN ANTONIO COMMUNITY COLLEGE"	& rank==	3
	replace todrop=1 if LAST==	"PULIDO"	& FIRST==	"MARK"	& BALDESIG==	"Governing Board Member/ABC USD"	& place==	"ABC UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"SHERMAN"	& FIRST==	"LEE"	& BALDESIG==	"Contractor"	& place==	"MOUNTAIN GATE CSD"	& rank==	6
	replace todrop=1 if LAST==	"TRAN"	& FIRST==	"JOHN"	& BALDESIG==	"Businessman/Parent"	& place==	"EL MONTE UNION HIGH"	& rank==	3
}

if $year==2010 {
	replace todrop=1 if LAST==	"ARELLANO"	& FIRST==	"PETER"	& BALDESIG==	"Medical Doctor/Councilman"	& place==	"GILROY"	& rank==	3
	replace todrop=1 if LAST==	"AYERS"	& FIRST==	"DAVID"	& BALDESIG==	"Physical Therapist"	& place==	"HANFORD"	& rank==	2
	replace todrop=1 if LAST==	"BALZARINI"	& FIRST==	"MATTHEW"	& BALDESIG==	"MHCSD Director/Police"	& place==	"LAMMERSVILLE ELEMENTARY"	& rank==	1
	replace todrop=1 if LAST==	"BARRA"	& FIRST==	"STEVEN"	& BALDESIG==	"Sales"	& place==	"WASHINGTON UNION HIGH"	& rank==	7
	replace todrop=1 if LAST==	"BECKHAM"	& FIRST==	"STANLEY"	& BALDESIG==	"Tehachapi City Councilman"	& place==	"TEHACHAPI"	& rank==	5
	replace todrop=1 if LAST==	"BENSON"	& FIRST==	"DAWN"	& BALDESIG==	"Water Agency Administration"	& place==	"ALAMEDA"	& rank==	2
	replace todrop=1 if LAST==	"BOOKER"	& FIRST==	"ANDRE"	& BALDESIG==	"Union Official"	& place==	"HANFORD"	& rank==	4
	replace todrop=1 if LAST==	"BROWN"	& FIRST==	"MARY"	& BALDESIG==	"Retired Restaurant Manager"	& place==	"TUOLUMNE"	& rank==	3
	replace todrop=1 if LAST==	"BUSTAMONTE"	& FIRST==	"ARTHUR"	& BALDESIG==	"Board Member/Chaffey Joint Union High School District"	& place==	"CHAFFEY JOINT UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"BUTTERFIELD"	& FIRST==	"FRANK"	& BALDESIG==	"Insurance Agent"	& place==	"NEWLY UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"CURTIS"	& FIRST==	"JAMES"	& BALDESIG==	"Agriculture Management"	& place==	"NEWLY UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"DANIELS"	& FIRST==	"BRET"	& BALDESIG==	"Public Safety Director"	& place==	"CITRUS HEIGHTS"	& rank==	4
	replace todrop=1 if LAST==	"DIVINE"	& FIRST==	"ROBERT"	& BALDESIG==	"Teacher/Coach"	& place==	"GROSSMONT UNION HIGH"	& rank==	5
	replace todrop=1 if LAST==	"DOMINGUEZ"	& FIRST==	"JORGE"	& BALDESIG==	"Incumbent"	& place==	"SOUTHWESTERN COMMUNITY COLLEGE"	& rank==	4
	replace todrop=1 if LAST==	"DUNLAP"	& FIRST==	"JUDY"	& BALDESIG==	"City Councilwoman/Teacher"	& place==	"INGLEWOOD"	& rank==	3
	replace todrop=1 if LAST==	"ESPINOZA"	& FIRST==	"RODRIGO"	& BALDESIG==	"Councilmember"	& place==	"LIVINGSTON"	& rank==	1
	replace todrop=1 if LAST==	"FILIPPI"	& FIRST==	"PETER"	& BALDESIG==	"Fresno County Appraiser/Businessman"	& place==	"FRESNO"	& rank==	3
	replace todrop=1 if LAST==	"FOBERT"	& FIRST==	"BEN"	& BALDESIG==	"Vice Principal/Teacher"	& place==	"LAMMERSFIELD JOINT UNIFIED - PROPOSED"	& rank==	3
	replace todrop=1 if LAST==	"FONLEY"	& FIRST==	"SANDY"	& BALDESIG==	"Incumbent"	& place==	"MARYSVILLE JOINT UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"FUENTES"	& FIRST==	"SUSANA"	& BALDESIG==	"Transportation/Freight Broker"	& place==	"TUOLUMNE"	& rank==	2
	replace todrop=1 if LAST==	"GEORGE"	& FIRST==	"MARLENE"	& BALDESIG==	"Legal Secretary"	& place==	"WASHINGTON UNION HIGH"	& rank==	8
	replace todrop=1 if LAST==	"HERRERA"	& FIRST==	"MANUEL"	& BALDESIG==	"Governing Board Member/East Side Union High School District"	& place==	"EAST SIDE UNION HIGH"	& rank==	1
	replace todrop=1 if LAST==	"HIRAMOTO"	& FIRST==	"JAMES"	& BALDESIG==	"Director/School Psychologist"	& place==	"LAMMERSFIELD JOINT UNIFIED - PROPOSED"	& rank==	5
	replace todrop=1 if LAST==	"HOWARD"	& FIRST==	"BD"	& BALDESIG==	"Independent Marketing Consultant"	& place==	"SOUTH BAY UNION ELEMENTARY"	& rank==	6
	replace todrop=1 if LAST==	"JEANDRON"	& FIRST==	"GARY"	& BALDESIG==	"Board Member/Teacher"	& place==	"PALM SPRINGS UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"JOHNSON"	& FIRST==	"NANCY"	& BALDESIG==	"Retired Business Owner"	& place==	"MORRO BAY"	& rank==	1 & month(date)==11
	replace todrop=1 if LAST==	"JOHNSONHILL"	& FIRST==	"BRENDA"	& BALDESIG==	"Educator/Counselor"	& place==	"SEQUOIAS COMMUNITY COLLEGE"	& rank==	2
	replace todrop=1 if LAST==	"KEEFE"	& FIRST==	"VICKI"	& BALDESIG==	"Retired Businesswoman"	& place==	"MARIPOSA"	& rank==	1
	replace todrop=1 if LAST==	"KENNEDY"	& FIRST==	"DONNA"	& BALDESIG==	"Retired Master Sergeant"	& place==	"MORRO BAY"	& rank==	4 & month(date)==11
	replace todrop=1 if LAST==	"KHANNA"	& FIRST==	"ATUL"	& BALDESIG==	"Physician/Board Member"	& place==	"LAMMERSFIELD JOINT UNIFIED - PROPOSED"	& rank==	8
	replace todrop=1 if LAST==	"LEAGE"	& FIRST==	"GEORGE"	& BALDESIG==	"Businessman"	& place==	"MORRO BAY"	& rank==	2
	replace todrop=1 if LAST==	"LECKNESS"	& FIRST==	"DAVID"	& BALDESIG==	"Mission Viejo Councilman/Businessman"	& place==	"MISSION VIEJO"	& rank==	2
	replace todrop=1 if LAST==	"MANOS"	& FIRST==	"STEVE"	& BALDESIG==	"Businessman"	& place==	"LAKE ELSINORE"	& rank==	4
	replace todrop=1 if LAST==	"MARKOVICH"	& FIRST==	"PETER"	& BALDESIG==	"General Contractor"	& place==	"RIM OF THE WORLD UNIFIED"	& rank==	1
	replace todrop=1 if LAST==	"MASON"	& FIRST==	"ENSEN"	& BALDESIG==	"Business Owner/Accountant"	& place==	"VICTOR VALLEY UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"MILLER"	& FIRST==	"GARY"	& BALDESIG==	"Retired Teacher"	& place==	"CAPISTRANO UNIFIED"	& rank==	3
	replace todrop=1 if LAST==	"MORENO"	& FIRST==	"JOSE"	& BALDESIG==	"Parent/Eligibility Technician"	& place==	"ANAHEIM UNION HIGH"	& rank==	5
	replace todrop=1 if LAST==	"MULLIN"	& FIRST==	"JOHN"	& BALDESIG==	"Poway City Councilmember"	& place==	"POWAY"	& rank==	1
	replace todrop=1 if LAST==	"NEJEDLY"	& FIRST==	"JOHN"	& BALDESIG==	"Contra Costa Community College District Governing Board Member"	& place==	"CONTRA COSTA COMMUNITY COLLEGE"	& rank==	1
	replace todrop=1 if LAST==	"NIELSON"	& FIRST==	"SHANE"	& BALDESIG==	"Paralegal"	& place==	"LAMMERSFIELD JOINT UNIFIED - PROPOSED"	& rank==	6
	replace todrop=1 if LAST==	"OSEGUERA"	& FIRST==	"MIGUEL"	& BALDESIG==	"Pharmacy Technician/Firefighter"	& place==	"HUGHSON"	& rank==	3
	replace todrop=1 if LAST==	"PATINO"	& FIRST==	"ALICE"	& BALDESIG==	"Current Councilwoman"	& place==	"SANTA MARIA"	& rank==	1
	replace todrop=1 if LAST==	"POMBO"	& FIRST==	"DAVID"	& BALDESIG==	"Farmer/Rancher/Realtor"	& place==	"LAMMERSVILLE ELEMENTARY"	& rank==	2
	replace todrop=1 if LAST==	"RAMIREZ"	& FIRST==	"FRANCISCO"	& BALDESIG==	"Businessman/Computer Engineer"	& place==	"HANFORD"	& rank==	3
	replace todrop=1 if LAST==	"RESENDEZ"	& FIRST==	"AARON"	& BALDESIG==	"Small Business Owner"	& place==	"ALUM ROCK UNION ELEMENTARY"	& rank==	9
	replace todrop=1 if LAST==	"RICHARDSON"	& FIRST==	"LEW"	& BALDESIG==	"Retired Sheriff's Deputy"	& place==	"TUOLUMNE"	& rank==	2
	replace todrop=1 if LAST==	"ROGOFF"	& FIRST==	"ROSALIND"	& BALDESIG==	"Online College Instructor"	& place==	"ALAMEDA"	& rank==	4
	replace todrop=1 if LAST==	"ROSS"	& FIRST==	"EMERY"	& BALDESIG==	"Rancher"	& place==	"MARIPOSA"	& rank==	1
	replace todrop=1 if LAST==	"RUIZ"	& FIRST==	"TERESA"	& BALDESIG==	"Small Business Owner"	& place==	"NEWLY UNIFIED"	& rank==	2
	replace todrop=1 if LAST==	"SCATTINI"	& FIRST==	"ROBERT"	& BALDESIG==	"San Benito County Marshal"	& place==	"HOLLISTER"	& rank==	1
	replace todrop=1 if LAST==	"SHAND"	& FIRST==	"JAMES"	& BALDESIG==	"Retired Manufacturing Supervisor"	& place==	"CONTRA COSTA"	& rank==	4
	replace todrop=1 if LAST==	"SMITH"	& FIRST==	"JACK"	& BALDESIG==	"Marketing Director"	& place==	"MORRO BAY"	& rank==	3
	replace todrop=1 if LAST==	"STEELE"	& FIRST==	"EDWARD"	& BALDESIG==	"Incumbent"	& place==	"DUNSMUIR"	& rank==	1
	replace todrop=1 if LAST==	"TABOR"	& FIRST==	"DANIEL"	& BALDESIG==	"Councilman/City of Inglewood"	& place==	"INGLEWOOD"	& rank==	1
	replace todrop=1 if LAST==	"TEMS"	& FIRST==	"BOB"	& BALDESIG==	"Retired Aerospace Manager"	& place==	"EASTERN SIERRA UNIFIED - ANTELOPE"	& rank==	1
	replace todrop=1 if LAST==	"TOMPKINS"	& FIRST==	"JASON"	& BALDESIG==	"Logistics Officer"	& place==	"WASHINGTON UNION HIGH"	& rank==	5
	replace todrop=1 if LAST==	"TWISSELMAN"	& FIRST==	"CARL"	& BALDESIG==	"Incumbent"	& place==	"TAFT UNION HIGH"	& rank==	2
	replace todrop=1 if LAST==	"VERGARA"	& FIRST==	"MICAELA"	& BALDESIG==	"Teacher"	& place==	"LAMMERSFIELD JOINT UNIFIED - PROPOSED"	& rank==	4
	replace todrop=1 if LAST==	"VILLARREAL"	& FIRST==	"WALTER"	& BALDESIG==	"Incumbent"	& place==	"FRESNO"	& rank==	5
	replace todrop=1 if LAST==	"VONHEEDERLEOPOLD"	& FIRST==	"GEORGEAN"	& BALDESIG==	"Appointed Incumbent"	& place==	"CONTRA COSTA"	& rank==	2
	replace todrop=1 if LAST==	"WILDE"	& FIRST==	"LESLIE"	& BALDESIG==	"Business Owner"	& place==	"DUNSMUIR"	& rank==	7
	replace todrop=1 if LAST==	"ZUMWALT"	& FIRST==	"JOHN"	& BALDESIG==	"Incumbent"	& place==	"COLLEGE OF THE SEQUOIAS"	& rank==	1	
}

if $year==2011 {
	replace todrop=1 if LAST==	"DEWILDER"	& FIRST==	"JAMES"	& BALDESIG==	"Incumbent"	& place==	"Arena Union Elementary"	& rank==	2
	replace todrop=1 if LAST==	"GARDINER"	& FIRST==	"BOB"	& BALDESIG==	"Farmer"	& place==	"Point Arena Joint Union High"	& rank==	3
	replace todrop=1 if LAST==	"MILES"	& FIRST==	"RON"	& BALDESIG==	"Appointed Incumbent"	& place==	"Arena Union Elementary"	& rank==	3
	replace todrop=1 if LAST==	"MITCHELL"	& FIRST==	"JOHN"	& BALDESIG==	"Incumbent"	& place==	"Riverbank Unified"	& rank==	1
	replace todrop=1 if LAST==	"NACCACHIAN"	& FIRST==	"PAUL"	& BALDESIG==	"Business Owner/Mediator"	& place==	"Azusa Unified"	& rank==	4
	replace todrop=1 if LAST==	"NAGEL"	& FIRST==	"TERRY"	& BALDESIG==	"Incumbent"	& place==	"Burlingame"	& rank==	2
	replace todrop=1 if LAST==	"RUSH"	& FIRST==	"SUZANNE"	& BALDESIG==	"Business Administrator"	& place==	"Arena Union Elementary"	& rank==	4
	replace todrop=1 if LAST==	"SCOTT"	& FIRST==	"OTHA"	& BALDESIG==	"Educator"	& place==	"Compton"	& rank==	6
}

if $year==2012 {
	replace todrop=1 if LAST==	"BARRERA"	& FIRST==	"RICHARD"	& BALDESIG==	"Board Trustee, San Diego Unified School District"	& place==	"San Diego Unified"	& rank==	1 & month(date)==11
	replace todrop=1 if LAST==	"BERUBE"	& FIRST==	"CYNTHIA"	& BALDESIG==	"Incumbent"	& place==	"Central Unified"	& rank==	1
	replace todrop=1 if LAST==	"BRYANT"	& FIRST==	"MICHAEL"	& BALDESIG==	"Real Estate Agent"	& place==	"Dos Palos-Oro Loma Joint Unified"	& rank==	6
	replace todrop=1 if LAST==	"CASTILLO"	& FIRST==	"JOSEPH"	& BALDESIG==	"Incumbent"	& place==	"Dos Palos-Oro Loma Joint Unified"	& rank==	3
	replace todrop=1 if LAST==	"CATRINA"	& FIRST==	"ALBERT"	& BALDESIG==	"Farmer"	& place==	"Dos Palos-Oro Loma Joint Unified"	& rank==	3
	replace todrop=1 if LAST==	"COX"	& FIRST==	"TERRY"	& BALDESIG==	"Incumbent"	& place==	"Central Unified"	& rank==	1
	replace todrop=1 if LAST==	"CUCLIS"	& FIRST==	"GINA"	& BALDESIG==	"Parent/Business Owner"	& place==	"Sonoma County Office of Education"	& rank==	1
	replace todrop=1 if LAST==	"DAY"	& FIRST==	"CHARLES"	& BALDESIG==	""	& place==	"Tuolumne"	& rank==	3
	replace todrop=1 if LAST==	"DELOSSANTOS"	& FIRST==	"CYNTHIA"	& BALDESIG==	"College Student"	& place==	"Colton Joint Unified"	& rank==	3
	replace todrop=1 if LAST==	"FLORES"	& FIRST==	"DANIEL"	& BALDESIG==	"Chief of Staff"	& place==	"Colton Joint Unified"	& rank==	2
	replace todrop=1 if LAST==	"FONTANA"	& FIRST==	"ERIC"	& BALDESIG==	"Incumbent"	& place==	"Dos Palos-Oro Loma Joint Unified"	& rank==	4
	replace todrop=1 if LAST==	"GARCIA"	& FIRST==	"CARMELITA"	& BALDESIG==	"Incumbent"	& place==	"Pacific Grove"	& rank==	2
	replace todrop=1 if LAST==	"GAULT"	& FIRST==	"MICHELLE"	& BALDESIG==	"General Manager"	& place==	"Portola"	& rank==	3
	replace todrop=1 if LAST==	"GONZALEZ"	& FIRST==	"YVETTE"	& BALDESIG==	"Substance Abuse Counselor"	& place==	"Greenfield"	& rank==	4
	replace todrop=1 if LAST==	"HERNANDEZ"	& FIRST==	"MATTHEW"	& BALDESIG==	"Parent"	& place==	"Colton Joint Unified"	& rank==	2
	replace todrop=1 if LAST==	"IBARRA"	& FIRST==	"FRANK"	& BALDESIG==	"Incumbent"	& place==	"Colton Joint Unified"	& rank==	4
	replace todrop=1 if LAST==	"JOHNSON"	& FIRST==	"DANNY"	& BALDESIG==	"No Ballot Designation"	& place==	"Mariposa"	& rank==	1
	replace todrop=1 if LAST==	"JOHNSTON"	& FIRST==	"MICHAEL"	& BALDESIG==	"Attorney"	& place==	"Yuba City Unified"	& rank==	3
	replace todrop=1 if LAST==	"KEZIRIAN"	& FIRST==	"GENE"	& BALDESIG==	"Certified Public Accountant"	& place==	"Central Unified"	& rank==	2
	replace todrop=1 if LAST==	"KIGER"	& FIRST==	"TRAVIS"	& BALDESIG==	"City Council Member, City of Fullerton"	& place==	"Fullerton"	& rank==	4
	replace todrop=1 if LAST==	"KINSELLA"	& FIRST==	"WILLIAM"	& BALDESIG==	"Incumbent"	& place==	"Mariposa"	& rank==	5
	replace todrop=1 if LAST==	"MARTINEZROACH"	& FIRST==	"PATRICIA"	& BALDESIG==	"Governing Board Member, East Side Union High School District"	& place==	"East Side Union High"	& rank==	3
	replace todrop=1 if LAST==	"MONTEZ"	& FIRST==	"ANDREW"	& BALDESIG==	"Student"	& place==	"Dos Palos-Oro Loma Joint Unified"	& rank==	6
	replace todrop=1 if LAST==	"NEWTON"	& FIRST==	"PHYLLIS"	& BALDESIG==	"Non-Profit Director"	& place==	"Sacramento"	& rank==	19
	replace todrop=1 if LAST==	"PEVERILL"	& FIRST==	"WILLIAM"	& BALDESIG==	"Incumbent"	& place==	"Central Unified"	& rank==	2
	replace todrop=1 if LAST==	"PINSON"	& FIRST==	"HARLEY"	& BALDESIG==	"Petroleum Counsel"	& place==	"Bakersfield"	& rank==	2
	replace todrop=1 if LAST==	"RAJCIC"	& FIRST==	"JOHN"	& BALDESIG==	"Retired Educator/Businessman"	& place==	"Ramona Unified"	& rank==	2
	replace todrop=1 if LAST==	"RAMIREZ"	& FIRST==	"LEONARD"	& BALDESIG==	"Special Education Teacher"	& place==	"Central Unified"	& rank==	1
	replace todrop=1 if LAST==	"RAMIREZ"	& FIRST==	"SAM"	& BALDESIG==	"Councilmember"	& place==	"Delano"	& rank==	4
	replace todrop=1 if LAST==	"REID"	& FIRST==	"ROBERTA"	& BALDESIG==	"No Ballot Designation"	& place==	"Fullerton"	& rank==	12
	replace todrop=1 if LAST==	"REYES"	& FIRST==	"RUDY"	& BALDESIG==	"Archaeologist/Scientist/Educator"	& place==	"Santee"	& rank==	2
	replace todrop=1 if LAST==	"RIVAS"	& FIRST==	"ANTONIO"	& BALDESIG==	"School Counselor/Teacher"	& place==	"Pajaro Valley Joint Unified"	& rank==	2
	replace todrop=1 if LAST==	"SANCHEZ"	& FIRST==	"SERGIO"	& BALDESIG==	"Councilmember/District Director"	& place==	"Salinas"	& rank==	2
	replace todrop=1 if LAST==	"SCOTT"	& FIRST==	"BECKY"	& BALDESIG==	"Real Estate Broker"	& place==	"Central Unified"	& rank==	2
	replace todrop=1 if LAST==	"SKOIEN"	& FIRST==	"MARK"	& BALDESIG==	""	& place==	"Tuolumne"	& rank==	4
	replace todrop=1 if LAST==	"SWEENEY"	& FIRST==	"THOMAS"	& BALDESIG==	"Retired College Educator"	& place==	"Alpine County Unified"	& rank==	4
	replace todrop=1 if LAST==	"VANDEBROOKE"	& FIRST==	"TOMI"	& BALDESIG==	"College Board President"	& place==	"Contra Costa Community College"	& rank==	3
	replace todrop=1 if LAST==	"VANWORTH"	& FIRST==	"BILL"	& BALDESIG==	"Retired School Teacher"	& place==	"Dos Palos-Oro Loma Joint Unified"	& rank==	2
	replace todrop=1 if LAST==	"VAZQUEZ"	& FIRST==	"AGAPITO"	& BALDESIG==	"City Council Member"	& place==	"Greenfield"	& rank==	3
	replace todrop=1 if LAST==	"WAAGE"	& FIRST==	"EDWARD"	& BALDESIG==	"Incumbent"	& place==	"Pismo Beach"	& rank==	1
	replace todrop=1 if LAST==	"WESTFALL"	& FIRST==	"DONNA"	& BALDESIG==	"Incumbent"	& place==	"Crescent City"	& rank==	5
	replace todrop=1 if LAST==	"WRIGHT"	& FIRST==	"JERMAINE"	& BALDESIG==	"Small Business Owner"	& place==	"Adelanto Elementary"	& rank==	1
}

if $year==2013 {
	replace todrop=1 if LAST==	"ADAMS"	& FIRST==	"DARRYL"	& place2013==	"Norwalk"
	replace todrop=1 if LAST==	"AMMON"	& FIRST==	"MARY"	& place2013==	"Las Virgenes Unified" & CNTYNAME=="LOS ANGELES"
	replace todrop=1 if LAST==	"BATES"	& FIRST==	"LESLIE"	& place2013==	"Arena Union Elementary/Point Arena Joint Union High"
	replace todrop=1 if LAST==	"CHANG"	& FIRST==	"JOSEPH"	& place2013==	"Hacienda La Puente Unified"
	replace todrop=1 if LAST==	"CIONE"	& FIRST==	"CINDY"	& place2013==	"Arena Union Elementary/Point Arena Joint Union High"
	replace todrop=1 if LAST==	"CUTBILL"	& FIRST==	"ANGELA"	& place2013==	"Las Virgenes Unified" & CNTYNAME=="VENTURA"
	replace todrop=1 if LAST==	"ESSER"	& FIRST==	"DAWN"	& place2013==	"Redondo Beach" & term2013=="Short"
	replace todrop=1 if LAST==	"LAWRENCE"	& FIRST==	"DALLAS"	& place2013==	"Las Virgenes Unified" & CNTYNAME=="LOS ANGELES"
	replace todrop=1 if LAST==	"MARQUEZ"	& FIRST==	"ANGELA"	& place2013==	"Arena Union Elementary/Point Arena Joint Union High"
	replace todrop=1 if LAST==	"PEARL"	& FIRST==	"RAY"	& place2013==	"Las Virgenes Unified" & CNTYNAME=="VENTURA"
	replace todrop=1 if LAST==	"ROBINSON"	& FIRST==	"VIKKI"	& place2013==	"Point Arena Joint Union High"
	replace todrop=1 if LAST==	"RUSH"	& FIRST==	"SUZANNE"	& place2013==	"Point Arena Joint Union High"
	replace todrop=1 if LAST==	"SHIMON"	& FIRST==	"ROBERT"	& place2013==	"Point Arena Joint Union High"
	replace todrop=1 if LAST==	"STEIN"	& FIRST==	"LESLI"	& place2013==	"Las Virgenes Unified" & CNTYNAME=="VENTURA"
	replace todrop=1 if LAST==	"DIELS"	& FIRST==	"STEVEN"	& place2013==	"Redondo Beach" &  & term2013=="Short"
	replace todrop=1 if LAST==	"ZURITA"	& FIRST==	"SATRA"	& place2013==	"Compton Unified"
}

if $year==2014 {
	replace todrop = 1 if  LAST==	"CHAVARIN"	& FIRST==	"VICTOR"	& BALDESIG==	"Student"	& place==	"Hanford Joint Union High"
	replace todrop = 1 if  LAST==	"DAVIS"	& FIRST==	"ALLISON"	& BALDESIG==	"Human Resources"	& place==	"Dos Palos-Oro Loma Unified"
	replace todrop = 1 if  LAST==	"DONAHUE"	& FIRST==	"BRIAN"	& BALDESIG==	"Retired University Professor"	& place==	"Huntington Beach City Elementary"
	replace todrop = 1 if  LAST==	"JOHNSON"	& FIRST==	"ALEX"	& BALDESIG==	"Education Policy Advisor"	& place==	"Los Angeles Unified" & term=="Short"
	replace todrop = 1 if  LAST==	"MCKENNA"	& FIRST==	"GEORGE"	& BALDESIG==	"Retired Principal/Superintendent"	& place==	"Los Angeles Unified" & term=="Short"
	replace todrop = 1 if  LAST==	"PERRY"	& FIRST==	"KIRK"	& BALDESIG==	"Retired Horse Rancher"	& place==	"Tuolumne"
	replace todrop = 1 if  LAST==	"ALCALA"	& FIRST==	"NORMA"	& BALDESIG==	"Parent/Education Director"	& place==	"Washington Unified"
	replace todrop = 1 if  LAST==	"AMARAL"	& FIRST==	"CHRIS"	& BALDESIG==	"Businessman"	& place==	"El Dorado"
	replace todrop = 1 if  LAST==	"AVILA"	& FIRST==	"PAUL"	& BALDESIG==	"Ontario City Councilman"	& place==	"Ontario"
	replace todrop = 1 if  LAST==	"BLAIR"	& FIRST==	"HOLLY"	& BALDESIG==	"Teacher/Professor"	& place==	"Lemoore"
	replace todrop = 1 if  LAST==	"BOWSER"	& FIRST==	"JEFF"	& BALDESIG==	"School Boardmember/Educator"	& place==	"Pleasanton Unified"
	replace todrop = 1 if  LAST==	"BROWN"	& FIRST==	"KEVIN"	& BALDESIG==	"School Board Member"	& place==	"El Dorado Union High"
	replace todrop = 1 if  LAST==	"CLAYPOOL"	& FIRST==	"JESSE"	& BALDESIG==	"Incumbent/Rancher Manager"	& place==	"Janesville Union Elementary"
	replace todrop = 1 if  LAST==	"COCHRANE"	& FIRST==	"ELLEN"	& BALDESIG==	"Public School Teacher"	& place==	"Sacramento City Unified"
	replace todrop = 1 if  LAST==	"DALATI"	& FIRST==	"MICHAEL"	& BALDESIG==	"Tax Instructor/Accountant"	& place==	"Santa Ana Unified"
	replace todrop = 1 if  LAST==	"DAWAR"	& FIRST==	"RAMA"	& BALDESIG==	"Businessman"	& place==	"Central Unified"
	replace todrop = 1 if  LAST==	"DELEHUNT"	& FIRST==	"LINDA"	& BALDESIG==	"Education Administrator"	& place==	"Orinda"
	replace todrop = 1 if  LAST==	"DUTRA"	& FIRST==	"JIMMY"	& BALDESIG==	"Farmer/Business Owner"	& place==	"Watsonville"
	replace todrop = 1 if  LAST==	"LAMPHIER"	& FIRST==	"TERRY"	& BALDESIG==	"Nevada County Supervisor/Businessman"	& place==	"Grass Valley"
	replace todrop = 1 if  LAST==	"LE"	& FIRST==	"VAN"	& BALDESIG==	"Governing Board Member"	& place==	"East Side Union High"
	replace todrop = 1 if  LAST==	"MARTINEZ"	& FIRST==	"FELIPE"	& BALDESIG==	"Retired"	& place==	"Porterville Unified"
	replace todrop = 1 if  LAST==	"MASON"	& FIRST==	"ENSEN"	& BALDESIG==	"CPA/Investment Advisor"	& place==	"Redlands Unified"
	replace todrop = 1 if  LAST==	"MCNEIL"	& FIRST==	"SCOTT"	& BALDESIG==	"Incumbent"	& place==	"El Dorado"
	replace todrop = 1 if  LAST==	"MENDOZA"	& FIRST==	"NATHANIEL"	& BALDESIG==	"Pastor"	& place==	"Dinuba"
	replace todrop = 1 if  LAST==	"OROZCO"	& FIRST==	"MARK"	& BALDESIG==	"Teacher/Business Owner"	& place==	"Beaumont"
	replace todrop = 1 if  LAST==	"PEREZ"	& FIRST==	"MANUEL"	& BALDESIG==	"California State Legislator"	& place==	"Coachella"
	replace todrop = 1 if  LAST==	"PICKARD"	& FIRST==	"LINCOLN"	& BALDESIG==	"Retired Contractor"	& place==	"South Bay Union Elementary"
	replace todrop = 1 if  LAST==	"PINGREY"	& FIRST==	"WINSTON"	& BALDESIG==	"Incumbent"	& place==	"Buckeye Union Elementary"
	replace todrop = 1 if  LAST==	"RHINEHART"	& FIRST==	"KEITH"	& BALDESIG==	"Retired UPS Management/Substitute Teacher"	& place==	"Santa Rosa"
	replace todrop = 1 if  LAST==	"ROCCO"	& FIRST==	"STEVE"	& BALDESIG==	"No Ballot Designation"	& place==	"Orange Unified"
	replace todrop = 1 if  LAST==	"SANDOVAL"	& FIRST==	"JUAN"	& BALDESIG==	"Assistant Superintendent"	& place==	"Kings Canyon Joint Unified"
	replace todrop = 1 if  LAST==	"SNYDER"	& FIRST==	"WILLIAM"	& BALDESIG==	"Incumbent"	& place==	"Merced Union High"
	replace todrop = 1 if  LAST==	"STRICKLAND"	& FIRST==	"GREG"	& BALDESIG==	"Prosecutor/Retired Military"	& place==	"Kings County Office of Education"
	replace todrop = 1 if  LAST==	"SWANSON"	& FIRST==	"ANGELA"	& BALDESIG==	"City Council Member"	& place==	"South Lake Tahoe"
	replace todrop = 1 if  LAST==	"YEP"	& FIRST==	"GARY"	& BALDESIG==	"Mayor/Business Owner"	& place==	"Kerman"
}

* Hand corrections of new round of elections
* Designate those elections in which the individual is running for a second time 
* Usually this is a different election cycle within the same year

if $year==1995 {
	replace runagain=1 if LAST==	"CABRERA"	& FIRST==	"ALFONSO"	& BALDESIG==	"Retired Administrator"	& place==	"COMPTON UNIFIED"	& rank==	8
	replace runagain=1 if LAST==	"DILLONKNUTSON"	& FIRST==	"CAROLE"	& BALDESIG==	"Businesswoman/College Trustee"	& place==	"NOVATO"	& rank==	1
	replace runagain=1 if LAST==	"GOODIN"	& FIRST==	"WALTER"	& BALDESIG==	"Paralegal"	& place==	"COMPTON UNIFIED"	& rank==	7
	replace runagain=1 if LAST==	"MEYERS"	& FIRST==	"GAIL"	& BALDESIG==	"Retired"	& place==	"NOVATO"	& rank==	7	
}			

if $year==1996 {
	replace runagain=1 if LAST==	"ARMENDARIZ"	& FIRST==	"ART"	& BALDESIG==	"Incumbent"	& place==	"DELANO"	& rank==	1
	replace runagain=1 if LAST==	"BILLS"	& FIRST==	"DON"	& BALDESIG==	"Retired Truck Driver"	& place==	"WHEATLAND"	& rank==	4
	replace runagain=1 if LAST==	"CARTMILL"	& FIRST==	"JAMES"	& BALDESIG==	"Chief Operating Officer"	& place==	"CHULA VISTA"	& rank==	2
	replace runagain=1 if LAST==	"CRAIK"	& FIRST==	"CAMERON"	& BALDESIG==	"General Contractor"	& place==	"ALPINE COUNTY UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"DYZYNSKE"	& FIRST==	"FRED"	& BALDESIG==	"Retired Businessman"	& place==	"PORTOLA"	& rank==	3
	replace runagain=1 if LAST==	"FLORES"	& FIRST==	"WAYNE"	& BALDESIG==	"Educator/Peace Officer"	& place==	"MANTECA"	& rank==	5
	replace runagain=1 if LAST==	"FLOREZ"	& FIRST==	"GRACE"	& BALDESIG==	"Incumbent"	& place==	"SANTA BARBARA & SNTA. BARB. HIGH"	& rank==	4
	replace runagain=1 if LAST==	"GELMAN"	& FIRST==	"RUTH"	& BALDESIG==	"Investor/Homemaker/Writer"	& place==	"KERN COMMUNITY COLLEGE"	& rank==	3
	replace runagain=1 if LAST==	"GIECK"	& FIRST==	"BOB"	& BALDESIG==	"No ballot designation"	& place==	"ROCKLIN"	& rank==	8
	replace runagain=1 if LAST==	"GLESS"	& FIRST==	"RONALD"	& BALDESIG==	"Electronic Technician"	& place==	"MARYSVILLE"	& rank==	4
	replace runagain=1 if LAST==	"HOWERTON"	& FIRST==	"JOYCE"	& BALDESIG==	"Mayor/Business Owner"	& place==	"LOMPC"	& rank==	1
	replace runagain=1 if LAST==	"HUME"	& FIRST==	"SNOW"	& BALDESIG==	"Certified Public Accountant"	& place==	"FULLERTON"	& rank==	7
	replace runagain=1 if LAST==	"KNEPPER"	& FIRST==	"DALE"	& BALDESIG==	"Board President/Businessman"	& place==	"FRESNO COUNTY BOARD OF EDUCATION"	& rank==	2
	replace runagain=1 if LAST==	"LAMADRID"	& FIRST==	"THOMAS"	& BALDESIG==	"County Equipment Operator"	& place==	"LAKESIDE UNION"	& rank==	3
	replace runagain=1 if LAST==	"MARIOTTI"	& FIRST==	"GRETCHEN"	& BALDESIG==	"Business Woman/Nurse"	& place==	"PINOLE"	& rank==	3
	replace runagain=1 if LAST==	"MCCANN"	& FIRST==	"FRANK"	& BALDESIG==	"Landscape Maintenance Businessman"	& place==	"ANTIOCH"	& rank==	5
	replace runagain=1 if LAST==	"MILLSAPS"	& FIRST==	"CLINTON"	& BALDESIG==	"No ballot designation"	& place==	"WILLOWS"	& rank==	5
	replace runagain=1 if LAST==	"MOOT"	& FIRST==	"JOHN"	& BALDESIG==	"Appointed Deputy Mayor"	& place==	"CHULA VISTA"	& rank==	1
	replace runagain=1 if LAST==	"MOTELL"	& FIRST==	"LISA"	& BALDESIG==	"No ballot designation"	& place==	"MARYSVILLE"	& rank==	6
	replace runagain=1 if LAST==	"PELLATZ"	& FIRST==	"CARL"	& BALDESIG==	"Insurance Agent/Broker"	& place==	"HUMBOLDT"	& rank==	3
	replace runagain=1 if LAST==	"PICO"	& FIRST==	"THOMAS"	& BALDESIG==	"Cert. Public Accountant/Inc. Councilmbr."	& place==	"PLEASANTON"	& rank==	1
	replace runagain=1 if LAST==	"REYNOLDS"	& FIRST==	"JOHN"	& BALDESIG==	"Incumbent"	& place==	"COARSEGOLD ELEMENTARY"	& rank==	1
	replace runagain=1 if LAST==	"ROUDEBUSH"	& FIRST==	"FRAN"	& BALDESIG==	"Incumbent"	& place==	"FEATHER RIVER COMMUNITY COLLEGE"	& rank==	2
	replace runagain=1 if LAST==	"SANCHEZ"	& FIRST==	"GONZALO"	& BALDESIG==	"Retired Border Patrol"	& place==	"CALEXICO UNIFIED"	& rank==	4
	replace runagain=1 if LAST==	"SANTOYA"	& FIRST==	"JOHN"	& BALDESIG==	"President/Taxwatchers Association"	& place==	"FRESNO UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"SUDARIO"	& FIRST==	"ANGEL"	& BALDESIG==	"Senior Pharmacy Analyst"	& place==	"ANTIOCH"	& rank==	2
	replace runagain=1 if LAST==	"VANCE"	& FIRST==	"ERNEST"	& BALDESIG==	"Retired College Administrator"	& place==	"LOS RIOS COMMUNITY COLLEGE"	& rank==	4
	replace runagain=1 if LAST==	"VANG"	& FIRST==	"CHARLES"	& BALDESIG==	"Executive Broadcaster"	& place==	"FRESNO COUNTY BOARD OF EDUCATION"	& rank==	4
	replace runagain=1 if LAST==	"WAGNER"	& FIRST==	"RANDY"	& BALDESIG==	"Business Owner"	& place==	"TEHAMA"	& rank==	3
	replace runagain=1 if LAST==	"WHITAKER"	& FIRST==	"BRUCE"	& BALDESIG==	"Business Financial Manager"	& place==	"FULLERTON"	& rank==	5
	replace runagain=1 if LAST==	"WILSON"	& FIRST==	"HELEN"	& BALDESIG==	"Councilmember/Businesswoman"	& place==	"LAKE FOREST"	& rank==	1
	replace runagain=1 if LAST==	"RICHEIMER"	& FIRST==	"JAMES"	& BALDESIG==	"Business Owner/Analyst"	& place==	"COAST COMMUNITY COLLEGE"	& rank==	2
	replace runagain=1 if LAST==	"PAVLIK"	& FIRST==	"MICHAEL"	& BALDESIG==	"Incumbent"	& place==	"YREKA UNION HIGH"	& rank==	3	
}			

if $year==1997 {
	replace runagain=1 if LAST==	"JONES"	& FIRST==	"AUDREY"	& BALDESIG==	"No ballot designation"	& place==	"KLAMATH-TRINITY JOINT UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"MACDONALD"	& FIRST==	"JAMES"	& BALDESIG==	"Journeyman Auto Mechanic"	& place==	"PITTSBURG UNIFIED"	& rank==	3
	replace runagain=1 if LAST==	"VISS"	& FIRST==	"DON"	& BALDESIG==	"Farmer"	& place==	"STANISLAUS COUNTY OFFICE OF EDUCATION"	& rank==	1		
}			

if $year==1998 {
	replace runagain=1 if LAST==	"ABBOTT"	& FIRST==	"LANCE"	& BALDESIG==	"Education Reformer/Financial Analyst"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"ANDRONICO"	& FIRST==	"SUSAN"	& BALDESIG==	"Journeyman/Retail Clerk"	& place==	"VACAVILLE"	& rank==	3
	replace runagain=1 if LAST==	"BRAUN"	& FIRST==	"SUSAN"	& BALDESIG==	"San Diego Unified School Board Member"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"CASS"	& FIRST==	"GARY"	& BALDESIG==	"CEO/Counselor/Educator"	& place==	"GROSSMONT UNION HIGH"	& rank==	2
	replace runagain=1 if LAST==	"CHRIST"	& FIRST==	"DELTA"	& BALDESIG==	"Council Member"	& place==	"ETNA"	& rank==	2
	replace runagain=1 if LAST==	"CORONADO"	& FIRST==	"ALEXANDRIA"	& BALDESIG==	"Teacher/Researcher/Businesswoman"	& place==	"ANAHEIM UNION HIGH"	& rank==	1
	replace runagain=1 if LAST==	"DANIELS"	& FIRST==	"BRET"	& BALDESIG==	"Deputy Sheriff"	& place==	"CITRUS HEIGHTS"	& rank==	3
	replace runagain=1 if LAST==	"DRAVES"	& FIRST==	"DENNIS"	& BALDESIG==	"Cable Tech./Pastor"	& place==	"WILLIAMS"	& rank==	4
	replace runagain=1 if LAST==	"HUDSON"	& FIRST==	"BILL"	& BALDESIG==	"Appointed Incumbent"	& place==	"SAUSALITO ELEMENTARY"	& rank==	3
	replace runagain=1 if LAST==	"HUME"	& FIRST==	"SNOW"	& BALDESIG==	"CPA/Fraud Investigator"	& place==	"FULLERTON"	& rank==	4
	replace runagain=1 if LAST==	"JOE"	& FIRST==	"ALEX"	& BALDESIG==	"Educator"	& place==	"ELK GROVE UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"JOHNSON"	& FIRST==	"GARY"	& BALDESIG==	"Investigator/Peace Officer"	& place==	"PETALUMA"	& rank==	6
	replace runagain=1 if LAST==	"KOBSEFF"	& FIRST==	"MICHAEL"	& BALDESIG==	"Small Business Owner"	& place==	"SISKIYOU UNION HIGH"	& rank==	3
	replace runagain=1 if LAST==	"MCSWEENEY"	& FIRST==	"MICHAEL"	& BALDESIG==	"Business Owner/General Contractor"	& place==	"SAN DIEGO CITY UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"MILLER"	& FIRST==	"JAMES"	& BALDESIG==	"Attorney"	& place==	"GROSSMONT UNION HIGH"	& rank==	6
	replace runagain=1 if LAST==	"MILLER"	& FIRST==	"MARQUIS"	& BALDESIG==	"Flight Instructor/Businessman"	& place==	"SAN LUIS OBISPO OFFICE OF EDUCATIO"	& rank==	1
	replace runagain=1 if LAST==	"MINARICK"	& FIRST==	"JOHNNEY"	& BALDESIG==	"Student and Handyman"	& place==	"GROSSMONT-CUYAMACA COMM. COLL."	& rank==	3
	replace runagain=1 if LAST==	"MOW"	& FIRST==	"VICTOR"	& BALDESIG==	"Scientist/Council Member"	& place==	"STOCKTON"	& rank==	1
	replace runagain=1 if LAST==	"PATTERSON"	& FIRST==	"BILL"	& BALDESIG==	"Small Business Owner"	& place==	"WINDSOR"	& rank==	4
	replace runagain=1 if LAST==	"RIDDLESPRIGGER"	& FIRST==	"BILL"	& BALDESIG==	"Incumbent"	& place==	"FRESNO UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"RIVERO"	& FIRST==	"JOSEPH"	& BALDESIG==	"Teacher"	& place==	"ATWATER"	& rank==	1
	replace runagain=1 if LAST==	"SANDOVAL"	& FIRST==	"GREG"	& BALDESIG==	"Board of Trustees/Sweetwater Union High School District"	& place==	"SWEETWATER UNION HIGH"	& rank==	1
	replace runagain=1 if LAST==	"STOWELL"	& FIRST==	"CRAIG"	& BALDESIG==	"Business Owner"	& place==	"EL TEJON UNIFIED"	& rank==	4
	replace runagain=1 if LAST==	"TASSONE"	& FIRST==	"GERARD"	& BALDESIG==	"Incumbent"	& place==	"GRASS VALLEY"	& rank==	1
	replace runagain=1 if LAST==	"WAGNER"	& FIRST==	"DONALD"	& BALDESIG==	"O.C. Businessman/Educator"	& place==	"S. ORANGE COUNTY COMM. COLLEGE"	& rank==	1
	replace runagain=1 if LAST==	"WALL"	& FIRST==	"DAVID"	& BALDESIG==	"No ballot designation"	& place==	"SAN JOSE UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"WALLER"	& FIRST==	"RAY"	& BALDESIG==	"Council Member"	& place==	"ETNA"	& rank==	1
	replace runagain=1 if LAST==	"WILLIAMS"	& FIRST==	"ELIZABETH"	& BALDESIG==	"Council Member"	& place==	"GONZALES"	& rank==	4
	replace runagain=1 if LAST=="STANTON" & FIRST=="JAMES" & BALDESIG=="Incumbent" & place=="CARLSBAD"		
}			

if $year==1999 {
	replace runagain=1 if LAST==	"MCNAIR"	& FIRST==	"MILDRED"	& BALDESIG==	"Educator/Business Woman"	& place==	"EL CAMINO COMMUNITY COLLEGE"	& rank==	2
	replace runagain=1 if LAST==	"REDENIUS"	& FIRST==	"MARK"	& BALDESIG==	"U.S. Postal Worker"	& place==	"BLACK BUTTE UNION ELEMENTARY"	& rank==	2		
}			

if $year==2000 {
	replace runagain=1 if LAST==	"BUSBY"	& FIRST==	"JAMES"	& BALDESIG==	"Businessman"	& place==	"VICTORVILLE"	& rank==	4
	replace runagain=1 if LAST==	"COLENZO"	& FIRST==	"ROBERT"	& BALDESIG==	"Local Business Owner"	& place==	"EL DORADO HILLS CSD"	& rank==	5
	replace runagain=1 if LAST==	"DICKEY"	& FIRST==	"DAVID"	& BALDESIG==	"Self-Employed Businessman"	& place==	"UKIAH"	& rank==	3
	replace runagain=1 if LAST==	"DODSON"	& FIRST==	"MARION"	& BALDESIG==	"Solana Beach City Councilmember"	& place==	"SOLANA BEACH"	& rank==	4
	replace runagain=1 if LAST==	"EVANS"	& FIRST==	"NOREEN"	& BALDESIG==	"Councilwoman/Businesswoman/Mother"	& place==	"SANTA ROSA"	& rank==	2
	replace runagain=1 if LAST==	"FRITCHEN"	& FIRST==	"DALE"	& BALDESIG==	"Chief/Child Protection"	& place==	"MANTECA UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"GARCIA"	& FIRST==	"EDWARD"	& BALDESIG==	"Defense Worker"	& place==	"STOCKTON CITY UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"JUKUSKY"	& FIRST==	"PETER"	& BALDESIG==	"Executive Director"	& place==	"WILLIAMS"	& rank==	2
	replace runagain=1 if LAST==	"KERN"	& FIRST==	"DAVID"	& BALDESIG==	"Air Traffic Controller"	& place==	"SACRAMENTO CITY UNIFIED"	& rank==	5
	replace runagain=1 if LAST==	"KIDD"	& FIRST==	"QUINTIN"	& BALDESIG==	"Mayor/City of Brentwood"	& place==	"BRENTWOOD"	& rank==	2
	replace runagain=1 if LAST==	"LISHMAN"	& FIRST==	"KATHI"	& BALDESIG==	"Teacher/City Councilmember"	& place==	"PLACERVILLE"	& rank==	1
	replace runagain=1 if LAST==	"MELENDEZ"	& FIRST==	"GEORGE"	& BALDESIG==	"Retired Educator"	& place==	"SAN JOSE-EVERGREEN COMMUNITY COLLEGE"	& rank==	2
	replace runagain=1 if LAST==	"MORENO"	& FIRST==	"JOSE"	& BALDESIG==	"Account Representative"	& place==	"RANCHO SANTIAGO COMMUNITY COLLEGE"	& rank==	3
	replace runagain=1 if LAST==	"SCANNELL"	& FIRST==	"DANIEL"	& BALDESIG==	"Public Interest Advocate"	& place==	"DUBLIN SAN RAMON CSD"	& rank==	4
	replace runagain=1 if LAST==	"WHITE"	& FIRST==	"MICHAEL"	& BALDESIG==	"Businessman"	& place==	"WASCO"	& rank==	4
	replace runagain=1 if LAST==	"WILLIAMS"	& FIRST==	"GEORGE"	& BALDESIG==	"Consultant/City Council"	& place==	"AUBURN"	& rank==	1
	replace runagain=1 if LAST==	"WILSON"	& FIRST==	"ROBERT"	& BALDESIG==	"Systems Analyst"	& place==	"COLTON"	& rank==	2		
}			

if $year==2001 {
	replace runagain=1 if LAST==	"GARCIA"	& FIRST==	"EVARISTO"	& BALDESIG==	"Sports Organizer"	& place==	"COMPTON COMMUNITY COLLEGE"	& rank==	4
	replace runagain=1 if LAST==	"KIMBREW"	& FIRST==	"BASIL"	& BALDESIG==	"School Board Member"	& place==	"COMPTON UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"LEWIS"	& FIRST==	"JOSEPH"	& BALDESIG==	"Child Development Educator"	& place==	"COMPTON UNIFIED"	& rank==	17
	replace runagain=1 if LAST==	"MORA"	& FIRST==	"JUAN"	& BALDESIG==	"Locomotive Engineer"	& place==	"COMPTON UNIFIED"	& rank==	14
	replace runagain=1 if LAST==	"RIOS"	& FIRST==	"EVA"	& BALDESIG==	"Incumbent"	& place==	"GONZALES UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"SHARIF"	& FIRST==	"EMMA"	& BALDESIG==	"Youth Development Coordinator"	& place==	"COMPTON UNIFIED"	& rank==	7
	replace runagain=1 if LAST==	"SWANSON"	& FIRST==	"JUDY"	& BALDESIG==	"Homemaker"	& place==	"LANCASTER ELEMENTARY"	& rank==	5		
}			

if $year==2002 {
	replace runagain=1 if LAST==	"ARAFILES"	& FIRST==	"FELICIA"	& BALDESIG==	"Self-Employed/Businesswoman"	& place==	"STOCKTON"	& rank==	2
	replace runagain=1 if LAST==	"AVILA"	& FIRST==	"PAUL"	& BALDESIG==	"Retired State Counselor"	& place==	"ONTARIO"	& rank==	6
	replace runagain=1 if LAST==	"BENIGNO"	& FIRST==	"GREGORY"	& BALDESIG==	"Business Owner/Agent"	& place==	"STOCKTON"	& rank==	2
	replace runagain=1 if LAST==	"BLOWERS"	& FIRST==	"MELODIE"	& BALDESIG==	"School Board Trustee"	& place==	"LINCOLN UNIFIED"	& rank==	4
	replace runagain=1 if LAST==	"BUNTHOFF"	& FIRST==	"THOMAS"	& BALDESIG==	"No ballot designation"	& place==	"DOS PALOS"	& rank==	2
	replace runagain=1 if LAST==	"CORNELL"	& FIRST==	"MICHAEL"	& BALDESIG==	"Businessman"	& place==	"EL CAJON"	& rank==	4
	replace runagain=1 if LAST==	"CROW"	& FIRST==	"VICKY"	& BALDESIG==	"Certified Public Accountant"	& place==	"FRESNO"	& rank==	1
	replace runagain=1 if LAST==	"DANIELS"	& FIRST==	"BRET"	& BALDESIG==	"Councilman/City of Citrus Heights"	& place==	"CITRUS HEIGHTS"	& rank==	3
	replace runagain=1 if LAST==	"DAYSOG"	& FIRST==	"TONY"	& BALDESIG==	"Alameda City Councilmember"	& place==	"ALAMEDA"	& rank==	1
	replace runagain=1 if LAST==	"DICTOS"	& FIRST==	"PAUL"	& BALDESIG==	"CPA/Auditor/Controller"	& place==	"FRESNO"	& rank==	2
	replace runagain=1 if LAST==	"FLICKINGER"	& FIRST==	"BONNIE"	& BALDESIG==	"City Councilmember"	& place==	"MORENO VALLEY"	& rank==	1
	replace runagain=1 if LAST==	"GARZA"	& FIRST==	"OSCAR"	& BALDESIG==	"Library Commissioner/Educator"	& place==	"SANTA ANA UNIFIED"	& rank==	5
	replace runagain=1 if LAST==	"GIOVANETTI"	& FIRST==	"GARY"	& BALDESIG==	"Incumbent"	& place==	"STOCKTON"	& rank==	1
	replace runagain=1 if LAST==	"GOMEZ"	& FIRST==	"RAMON"	& BALDESIG==	"Paralegal/Council Member"	& place==	"WATSONVILLE"	& rank==	1
	replace runagain=1 if LAST==	"HOFFMAN"	& FIRST==	"RANDY"	& BALDESIG==	"Planning Commissioner/Businessman"	& place==	"THOUSAND OAKS"	& rank==	2
	replace runagain=1 if LAST==	"KENNEDY"	& FIRST==	"DENNIS"	& BALDESIG==	"Mayor"	& place==	"MORGAN HILL"	& rank==	1
	replace runagain=1 if LAST==	"LANE"	& FIRST==	"JOHN"	& BALDESIG==	"Chief Investigator/Educator"	& place==	"VENTURA COUNTY OFFICE OF EDUCATION"	& rank==	2
	replace runagain=1 if LAST==	"LARSON"	& FIRST==	"PHIL"	& BALDESIG==	"Farmer/Businessman"	& place==	"FRESNO"	& rank==	1 & month(date)==11
	replace runagain=1 if LAST==	"MARTINEZROACH"	& FIRST==	"PATRICIA"	& BALDESIG==	"Schoolteacher/Mother/Consultant"	& place==	"EAST SIDE UNION HIGH"	& rank==	3
	replace runagain=1 if LAST==	"ORTIZ"	& FIRST==	"FRANCIS"	& BALDESIG==	"Incumbent"	& place==	"WOODLAKE"	& rank==	1
	replace runagain=1 if LAST==	"PALLA"	& FIRST==	"JEANETTE"	& BALDESIG==	"Family Law Facilitator"	& place==	"TINITY"	& rank==	2
	replace runagain=1 if LAST==	"PERRY"	& FIRST==	"CARLON"	& BALDESIG==	"Mayor"	& place==	"MANTECA"	& rank==	2
	replace runagain=1 if LAST==	"POWERS"	& FIRST==	"GREGORY"	& BALDESIG==	"Dana Point Businessman"	& place==	"DANA POINT"	& rank==	5
	replace runagain=1 if LAST==	"RODRIGUEZ"	& FIRST==	"TRINIDAD"	& BALDESIG==	"Businessman"	& place==	"KERMAN"	& rank==	1
	replace runagain=1 if LAST==	"RUSH"	& FIRST==	"BRET"	& BALDESIG==	"Administrative Director"	& place==	"FRESNO UNIFIED"	& rank==	3
	replace runagain=1 if LAST==	"STIERINGER"	& FIRST==	"JAMES"	& BALDESIG==	"Treasurer/Healthcare District"	& place==	"LA MESA"	& rank==	1
	replace runagain=1 if LAST==	"WOODWARD"	& FIRST==	"JAMES"	& BALDESIG==	"Attorney"	& place==	"TINITY"	& rank==	1	
}			

if $year==2003 {
	replace runagain=1 if LAST==	"ALMEIDA"	& FIRST==	"RUDY"	& BALDESIG==	"Retired Aerospace Coordinator"	& place==	"HACIENDA LA PUENTE UNIFIED"	& rank==	9
	replace runagain=1 if LAST==	"CHANG"	& FIRST==	"THOMAS"	& BALDESIG==	"Transportation Engineer/Teacher"	& place==	"HACIENDA LA PUENTE UNIFIED"	& rank==	3
	replace runagain=1 if LAST==	"EASTER"	& FIRST==	"FRED"	& BALDESIG==	"Retired School Administrator"	& place==	"COMPTON UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"HSU"	& FIRST==	"NORMAN"	& BALDESIG==	"Governing Board Member/Hacienda La Puente Unified School District"	& place==	"HACIENDA LA PUENTE UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"JOHNSON"	& FIRST==	"LORRAINE"	& BALDESIG==	"Councilwoman"	& place==	"INGLEWOOD"	& rank==	2
	replace runagain=1 if LAST==	"CHYR"	& FIRST==	"FRED"	& BALDESIG==	"Governing Board Member/Mt. San Antonio Community College"	& place==	"MT. SAN ANTONIO COMMUNITY COLLEGE"	& rank==	3		
}			

if $year==2004 {
	replace runagain=1 if LAST==	"BARAJAS"	& FIRST==	"PETRA"	& BALDESIG==	"Retired Realtor/Broker"	& place==	"SWEETWATER UNION HIGH"	& rank==	7
	replace runagain=1 if LAST==	"BILLS"	& FIRST==	"HARVEY"	& BALDESIG==	"Teacher/Retired Military"	& place==	"LODI UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"BUSCH"	& FIRST==	"JOHN"	& BALDESIG==	"Businessman"	& place==	"BIGGS"	& rank==	1
	replace runagain=1 if LAST==	"FRANKLIN"	& FIRST==	"BRETT"	& BALDESIG==	"Santa Ana Councilman/Businessman"	& place==	"RANCHO SANTIAGO COMMUNITY COLLEGE"	& rank==	5
	replace runagain=1 if LAST==	"FU"	& FIRST==	"FRANK"	& BALDESIG==	"State Law Enforcement"	& place==	"CHINO HILLS"	& rank==	4
	replace runagain=1 if LAST==	"JACOBI"	& FIRST==	"VERONICA"	& BALDESIG==	"Business Owner/Engineer"	& place==	"SANTA ROSA"	& rank==	5
	replace runagain=1 if LAST==	"JOHNSON"	& FIRST==	"RANDY"	& BALDESIG==	"Incumbent"	& place==	"SCOTTS VALLEY"	& rank==	2
	replace runagain=1 if LAST==	"LILBURN"	& FIRST==	"PENNY"	& BALDESIG==	"Incumbent"	& place==	"HIGHLAND"	& rank==	2
	replace runagain=1 if LAST==	"MARSH"	& FIRST==	"KERMIT"	& BALDESIG==	"Westminster City Councilmember"	& place==	"WESTMINSTER"	& rank==	1
	replace runagain=1 if LAST==	"MENDRIBIL"	& FIRST==	"JOHN"	& BALDESIG==	"Engineer Technician"	& place==	"ROHNERT PARK"	& rank==	9
	replace runagain=1 if LAST==	"MITOMA"	& FIRST==	"MICHAEL"	& BALDESIG==	"Businessman"	& place==	"CARSON"	& rank==	2
	replace runagain=1 if LAST==	"MOZENA"	& FIRST==	"STEVE"	& BALDESIG==	"Educational Materials Businessman"	& place==	"CARSON"	& rank==	10
	replace runagain=1 if LAST==	"PAPPAS"	& FIRST==	"STEVEN"	& BALDESIG==	"Businessman"	& place==	"LOS OLIVOS ELEMENTARY"	& rank==	3
	replace runagain=1 if LAST==	"PEOPLES"	& FIRST==	"JAMES"	& BALDESIG==	"Retired Administrator"	& place==	"CARSON"	& rank==	8
	replace runagain=1 if LAST==	"RABENALDT"	& FIRST==	"BILL"	& BALDESIG==	"Incumbent"	& place==	"PISMO BEACH"	& rank==	1
	replace runagain=1 if LAST==	"SCOTT"	& FIRST==	"EDWARD"	& BALDESIG==	"Business Owner"	& place==	"RIALTO"	& rank==	1
	replace runagain=1 if LAST==	"WOOD"	& FIRST==	"RONALD"	& BALDESIG==	"Retired Military/Corrections"	& place==	"LASSEN UNION HIGH"	& rank==	3
	replace runagain=1 if LAST==	"ZARAGOZA"	& FIRST==	"JOHN"	& BALDESIG==	"City Councilmember/Businessman"	& place==	"OXNARD"	& rank==	1		
}			

if $year==2005 {
	replace runagain=1 if LAST==	"AVALOS"	& FIRST==	"CARMEN"	& BALDESIG==	"Municipal Clerk/Educator"	& place==	"CERRITOS COMMUNITY COLLEGE"	& rank==	2
	replace runagain=1 if LAST==	"ESTRADA"	& FIRST==	"JOEL"	& BALDESIG==	"Public Relation Director"	& place==	"COMPTON UNIFIED"	& rank==	3
	replace runagain=1 if LAST==	"HUIZAR"	& FIRST==	"JOSE"	& BALDESIG==	"School Boardmember/Attorney"	& place==	"LOS ANGELES"	& rank==	1
	replace runagain=1 if LAST==	"MCDONALD"	& FIRST==	"DENNIS"	& BALDESIG==	"Retired Fire Chief"	& place==	"ROSEMEAD ELEMENTARY"	& rank==	2
	replace runagain=1 if LAST==	"TYE"	& FIRST==	"STEVE"	& BALDESIG==	"Businessman/Financial Advisor"	& place==	"DIAMOND BAR"	& rank==	1		
}			

if $year==2006 {
	replace runagain=1 if LAST==	"AGUILERA"	& FIRST==	"RENE"	& BALDESIG==	"Incumbent"	& place==	"ROSEVILLE CITY ELEMENTARY"	& rank==	3
	replace runagain=1 if LAST==	"CARRIZOSA"	& FIRST==	"CHRISTINA"	& BALDESIG==	"Elementary School Teacher"	& place==	"POMONA"	& rank==	1
	replace runagain=1 if LAST==	"FERNANDEZ"	& FIRST==	"LETICIA"	& BALDESIG==	"Self-Employed"	& place==	"GOLDEN PLAINS UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"GOMEZ"	& FIRST==	"TIM"	& BALDESIG==	"Parent/Business Owner"	& place==	"SAN YSIDRO ELEMENTARY"	& rank==	6
	replace runagain=1 if LAST==	"GUILLEN"	& FIRST==	"ROBERT"	& BALDESIG==	"Manufacturing Production Manager"	& place==	"RIO ELEMENTARY"	& rank==	1
	replace runagain=1 if LAST==	"GURULE"	& FIRST==	"MANUEL"	& BALDESIG==	"Businessman"	& place==	"BARSTOW"	& rank==	7
	replace runagain=1 if LAST==	"LAMPHIER"	& FIRST==	"TERRY"	& BALDESIG==	"No ballot designation"	& place==	"GRASS VALLEY"	& rank==	3
	replace runagain=1 if LAST==	"LOWENTHAL"	& FIRST==	"SUJA"	& BALDESIG==	"Member/Board of Education District 3"	& place==	"LONG BEACH UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"MAGUIRE"	& FIRST==	"PAUL"	& BALDESIG==	"Doctor/Businessman"	& place==	"AMERICAN CANYON"	& rank==	2
	replace runagain=1 if LAST==	"MAHAN"	& FIRST==	"PATRICIA"	& BALDESIG==	"Mayor of Santa Clara"	& place==	"SANTA CLARA"	& rank==	1
	replace runagain=1 if LAST==	"MIKELS"	& FIRST==	"MARJORIE"	& BALDESIG==	"Taxpayers' Advocate/Attorney"	& place==	"UPLAND"	& rank==	5
	replace runagain=1 if LAST==	"MILLER"	& FIRST==	"JOHN"	& BALDESIG==	"Deputy Labor Commissioner"	& place==	"AMERICAN CANYON"	& rank==	4 & month(date)==11
	replace runagain=1 if LAST==	"RODRIGUEZ"	& FIRST==	"DANIEL"	& BALDESIG==	"Incumbent"	& place==	"POMONA"	& rank==	2
	replace runagain=1 if LAST==	"RUSSELL"	& FIRST==	"BILL"	& BALDESIG==	"Business Person"	& place==	"AMERICAN CANYON"	& rank==	7
	replace runagain=1 if LAST==	"SHAWVER"	& FIRST==	"DAVID"	& BALDESIG==	"Councilman-Teacher-Coach"	& place==	"STANTON"	& rank==	3
	replace runagain=1 if LAST==	"TURNER"	& FIRST==	"ROSS"	& BALDESIG==	"Agriculturist/Business Man"	& place==	"CORNING"	& rank==	2
	replace runagain=1 if LAST==	"VALLE"	& FIRST==	"RICHARD"	& BALDESIG==	"Councilmember"	& place==	"UNION CITY"	& rank==	2
	replace runagain=1 if LAST==	"WALKER"	& FIRST==	"JAMES"	& BALDESIG==	"Student"	& place==	"AMERICAN CANYON"	& rank==	6 & month(date)==11
	replace runagain=1 if LAST==	"WINET"	& FIRST==	"RICK"	& BALDESIG==	"Member/La Mesa-Spring Valley School District Board"	& place==	"LA MESA-SPRING VALLEY"	& rank==	3
	replace runagain=1 if LAST==	"YOUNG"	& FIRST==	"ARNOLD"	& BALDESIG==	"Incumbent"	& place==	"WEST PATTON VILLAGE"	& rank==	1		
}			

if $year==2007 {
	*replace runagain=1 if LAST==	"ARRIGHI"	& FIRST==	"DANIEL"	& BALDESIG==	"Water Resources Manager"	& place==	"TEMPLE CITY UNIFIED"	& rank==	5
	replace runagain=1 if LAST==	"CASTRO"	& FIRST==	"AIDE"	& BALDESIG==	"Non-Profit Director/Businesswoman"	& place==	"LYNWOOD"	& rank==	1
	replace runagain=1 if LAST==	"JACINTO"	& FIRST==	"EDWIN"	& BALDESIG==	"Realtor"	& place==	"LYNWOOD"	& rank==	8
	replace runagain=1 if LAST==	"LAW"	& FIRST==	"MAYNARD"	& BALDESIG==	"Retired Educator/Administrator"	& place==	"ABC UNIFIED"	& rank==	4
	replace runagain=1 if LAST==	"RODRIGUEZ"	& FIRST==	"RAMON"	& BALDESIG==	"Businessman"	& place==	"LYNWOOD"	& rank==	7
	replace runagain=1 if LAST==	"SANCHEZ"	& FIRST==	"ADAM"	& BALDESIG==	"Planning Commissioner"	& place==	"DESERT HOT SPRINGS"	& rank==	2		
}			

if $year==2008 {
	replace runagain=1 if LAST==	"ALMONTE"	& FIRST==	"HERMY"	& BALDESIG==	"Property Manager/Parent"	& place==	"SAN LEANDRO UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"ALVAREZ"	& FIRST==	"EDDIE"	& BALDESIG==	"Businessman"	& place==	"SANTA ROSA"	& rank==	10
	replace runagain=1 if LAST==	"COFFEY"	& FIRST==	"CINDY"	& BALDESIG==	"Vice Mayor/Publisher"	& place==	"AMERICAN CANYON"	& rank==	2
	replace runagain=1 if LAST==	"DOUGLAS"	& FIRST==	"ROBERT"	& BALDESIG==	"Educator"	& place==	"ORANGE"	& rank==	3
	replace runagain=1 if LAST==	"FLORES"	& FIRST==	"ROBERT"	& BALDESIG==	"Business Owner"	& place==	"ANAHEIM"	& rank==	7
	replace runagain=1 if LAST==	"HUFFMAN"	& FIRST==	"ROBIN"	& BALDESIG==	"Social Science Instructor"	& place==	"PARADISE"	& rank==	5
	replace runagain=1 if LAST==	"MADDOX"	& FIRST==	"KENNETH"	& BALDESIG==	"School Board member/Businessman"	& place==	"CAPISTRANO UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"MARTINEZROACH"	& FIRST==	"PATRICIA"	& BALDESIG==	"Schoolteacher/Mother/Consultant"	& place==	"EAST SIDE UNION HIGH"	& rank==	2
	replace runagain=1 if LAST==	"MATEO"	& FIRST==	"CHRISTOPHER"	& BALDESIG==	"Retired Postal Clerk"	& place==	"LATHROP"	& rank==	2
	replace runagain=1 if LAST==	"MILLER"	& FIRST==	"GARY"	& BALDESIG==	"Retired Teacher"	& place==	"CAPISTRANO UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"OLIVER"	& FIRST==	"ROBERT"	& BALDESIG==	"Councilmember/Retired Minister"	& place==	"LATHROP"	& rank==	3
	replace runagain=1 if LAST==	"PALAZZO"	& FIRST==	"SUSAN"	& BALDESIG==	"Property Manager/Teacher"	& place==	"CAPISTRANO UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"PEREA"	& FIRST==	"HENRY"	& BALDESIG==	"City Council Member"	& place==	"FRESNO"	& rank==	2
	replace runagain=1 if LAST==	"REYES"	& FIRST==	"RUDY"	& BALDESIG==	"Archaeologist/Educator/Scientist"	& place==	"SANTEE"	& rank==	2
	replace runagain=1 if LAST==	"ROCHA"	& FIRST==	"MARY"	& BALDESIG==	"Program Director"	& place==	"ANTIOCH"	& rank==	1
	replace runagain=1 if LAST==	"SLERT"	& FIRST==	"CHARLES"	& BALDESIG==	"Architect"	& place==	"CRESENT CITY"	& rank==	1
	replace runagain=1 if LAST==	"SMITH"	& FIRST==	"TIM"	& BALDESIG==	"Councilmember"	& place==	"ROHNERT PARK"	& rank==	5
	replace runagain=1 if LAST==	"SWEARINGEN"	& FIRST==	"ROY"	& BALDESIG==	"Incumbent"	& place==	"PINOLE"	& rank==	2
	replace runagain=1 if LAST==	"TICHY"	& FIRST==	"MARK"	& BALDESIG==	"No ballot designation"	& place==	"SAN LEANDRO UNIFIED"	& rank==	4
	replace runagain=1 if LAST==	"WIESNER"	& FIRST==	"LAWRENCE"	& BALDESIG==	"Accountant/Homeschooler/Parent"	& place==	"SANTA ROSA"	& rank==	4
	replace runagain=1 if LAST==	"WINANT"	& FIRST==	"JERRY"	& BALDESIG==	"School Teacher/Administrator"	& place==	"ORANGE UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"YZAGUIRRE"	& FIRST==	"VINCENT"	& BALDESIG==	"Councilmember District 3"	& place==	"COLTON"	& rank==	1		
}			

if $year==2009 {
	replace runagain=1 if LAST==	"AVALOS"	& FIRST==	"CARMEN"	& BALDESIG==	"Governing Board Member"	& place==	"CERRITOS COMMUNITY COLLEGE"	& rank==	4
	replace runagain=1 if LAST==	"HELZER"	& FIRST==	"PAUL"	& BALDESIG==	"Incumbent"	& place==	"BELLFLOWER UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"PULIDO"	& FIRST==	"MARK"	& BALDESIG==	"Governing Board Member/ABC USD"	& place==	"ABC UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"SHERMAN"	& FIRST==	"LEE"	& BALDESIG==	"Contractor"	& place==	"MOUNTAIN GATE CSD"	& rank==	6
	replace runagain=1 if LAST==	"TRAN"	& FIRST==	"JOHN"	& BALDESIG==	"Businessman/Parent"	& place==	"EL MONTE UNION HIGH"	& rank==	3		
}			

if $year==2010 {
	replace runagain=1 if LAST==	"ARELLANO"	& FIRST==	"PETER"	& BALDESIG==	"Medical Doctor/Councilman"	& place==	"GILROY"	& rank==	3
	replace runagain=1 if LAST==	"AYERS"	& FIRST==	"DAVID"	& BALDESIG==	"Physical Therapist"	& place==	"HANFORD"	& rank==	2
	replace runagain=1 if LAST==	"BECKHAM"	& FIRST==	"STANLEY"	& BALDESIG==	"Tehachapi City Councilman"	& place==	"TEHACHAPI"	& rank==	5
	replace runagain=1 if LAST==	"BOOKER"	& FIRST==	"ANDRE"	& BALDESIG==	"Union Official"	& place==	"HANFORD"	& rank==	4
	replace runagain=1 if LAST==	"BUSTAMONTE"	& FIRST==	"ARTHUR"	& BALDESIG==	"Board Member/Chaffey Joint Union High School District"	& place==	"CHAFFEY JOINT UNION HIGH"	& rank==	1
	replace runagain=1 if LAST==	"DANIELS"	& FIRST==	"BRET"	& BALDESIG==	"Public Safety Director"	& place==	"CITRUS HEIGHTS"	& rank==	4
	replace runagain=1 if LAST==	"DOMINGUEZ"	& FIRST==	"JORGE"	& BALDESIG==	"Incumbent"	& place==	"SOUTHWESTERN COMMUNITY COLLEGE"	& rank==	4
	replace runagain=1 if LAST==	"DUNLAP"	& FIRST==	"JUDY"	& BALDESIG==	"City Councilwoman/Teacher"	& place==	"INGLEWOOD"	& rank==	3 & month(date)==11
	replace runagain=1 if LAST==	"ESPINOZA"	& FIRST==	"RODRIGO"	& BALDESIG==	"Councilmember"	& place==	"LIVINGSTON"	& rank==	1
	replace runagain=1 if LAST==	"FONLEY"	& FIRST==	"SANDY"	& BALDESIG==	"Incumbent"	& place==	"MARYSVILLE JOINT UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"HERRERA"	& FIRST==	"MANUEL"	& BALDESIG==	"Governing Board Member/East Side Union High School District"	& place==	"EAST SIDE UNION HIGH"	& rank==	1
	replace runagain=1 if LAST==	"HOWARD"	& FIRST==	"BD"	& BALDESIG==	"Independent Marketing Consultant"	& place==	"SOUTH BAY UNION ELEMENTARY"	& rank==	6
	replace runagain=1 if LAST==	"JEANDRON"	& FIRST==	"GARY"	& BALDESIG==	"Board Member/Teacher"	& place==	"PALM SPRINGS UNIFIED"	& rank==	2
	replace runagain=1 if LAST==	"JOHNSON"	& FIRST==	"NANCY"	& BALDESIG==	"Retired Business Owner"	& place==	"MORRO BAY"	& rank==	1 & month(date)==11
	replace runagain=1 if LAST==	"KENNEDY"	& FIRST==	"DONNA"	& BALDESIG==	"Retired Master Sergeant"	& place==	"MORRO BAY"	& rank==	4 & month(date)==11
	replace runagain=1 if LAST==	"LEAGE"	& FIRST==	"GEORGE"	& BALDESIG==	"Businessman"	& place==	"MORRO BAY"	& rank==	2
	replace runagain=1 if LAST==	"LECKNESS"	& FIRST==	"DAVID"	& BALDESIG==	"Mission Viejo Councilman/Businessman"	& place==	"MISSION VIEJO"	& rank==	2
	replace runagain=1 if LAST==	"MANOS"	& FIRST==	"STEVE"	& BALDESIG==	"Businessman"	& place==	"LAKE ELSINORE"	& rank==	4
	replace runagain=1 if LAST==	"MARKOVICH"	& FIRST==	"PETER"	& BALDESIG==	"General Contractor"	& place==	"RIM OF THE WORLD UNIFIED"	& rank==	1
	replace runagain=1 if LAST==	"MASON"	& FIRST==	"ENSEN"	& BALDESIG==	"Business Owner/Accountant"	& place==	"VICTOR VALLEY UNION HIGH"	& rank==	2
	replace runagain=1 if LAST==	"MILLER"	& FIRST==	"GARY"	& BALDESIG==	"Retired Teacher"	& place==	"CAPISTRANO UNIFIED"	& rank==	3
	replace runagain=1 if LAST==	"MULLIN"	& FIRST==	"JOHN"	& BALDESIG==	"Poway City Councilmember"	& place==	"POWAY"	& rank==	1
	replace runagain=1 if LAST==	"NEJEDLY"	& FIRST==	"JOHN"	& BALDESIG==	"Contra Costa Community College District Governing Board Member"	& place==	"CONTRA COSTA COMMUNITY COLLEGE"	& rank==	1
	replace runagain=1 if LAST==	"OSEGUERA"	& FIRST==	"MIGUEL"	& BALDESIG==	"Pharmacy Technician/Firefighter"	& place==	"HUGHSON"	& rank==	3
	replace runagain=1 if LAST==	"PATINO"	& FIRST==	"ALICE"	& BALDESIG==	"Current Councilwoman"	& place==	"SANTA MARIA"	& rank==	1
	replace runagain=1 if LAST==	"RAMIREZ"	& FIRST==	"FRANCISCO"	& BALDESIG==	"Businessman/Computer Engineer"	& place==	"HANFORD"	& rank==	3
	replace runagain=1 if LAST==	"RESENDEZ"	& FIRST==	"AARON"	& BALDESIG==	"Small Business Owner"	& place==	"ALUM ROCK UNION ELEMENTARY"	& rank==	9
	replace runagain=1 if LAST==	"SCATTINI"	& FIRST==	"ROBERT"	& BALDESIG==	"San Benito County Marshal"	& place==	"HOLLISTER"	& rank==	1
	replace runagain=1 if LAST==	"SMITH"	& FIRST==	"JACK"	& BALDESIG==	"Marketing Director"	& place==	"MORRO BAY"	& rank==	3
	replace runagain=1 if LAST==	"STEELE"	& FIRST==	"EDWARD"	& BALDESIG==	"Incumbent"	& place==	"DUNSMUIR"	& rank==	1
	replace runagain=1 if LAST==	"TEMS"	& FIRST==	"BOB"	& BALDESIG==	"Retired Aerospace Manager"	& place==	"EASTERN SIERRA UNIFIED - ANTELOPE"	& rank==	1
	replace runagain=1 if LAST==	"VILLARREAL"	& FIRST==	"WALTER"	& BALDESIG==	"Incumbent"	& place==	"FRESNO"	& rank==	5
	replace runagain=1 if LAST==	"WILDE"	& FIRST==	"LESLIE"	& BALDESIG==	"Business Owner"	& place==	"DUNSMUIR"	& rank==	7		
}			

if $year==2011 {
	replace runagain=1 if LAST==	"MITCHELL"	& FIRST==	"JOHN"	& BALDESIG==	"Incumbent"	& place==	"Riverbank Unified"	& rank==	1
	replace runagain=1 if LAST==	"NACCACHIAN"	& FIRST==	"PAUL"	& BALDESIG==	"Business Owner/Mediator"	& place==	"Azusa Unified"	& rank==	4
	replace runagain=1 if LAST==	"NAGEL"	& FIRST==	"TERRY"	& BALDESIG==	"Incumbent"	& place==	"Burlingame"	& rank==	2		
}			

if $year==2012 {
	replace runagain=1 if LAST==	"BARRERA"	& FIRST==	"RICHARD"	& BALDESIG==	"Board Trustee, San Diego Unified School District"	& place==	"San Diego Unified"	& rank==	1 & month(date)==11
	replace runagain=1 if LAST==	"CUCLIS"	& FIRST==	"GINA"	& BALDESIG==	"Parent/Business Owner"	& place==	"Sonoma County Office of Education"	& rank==	1
	replace runagain=1 if LAST==	"GARCIA"	& FIRST==	"CARMELITA"	& BALDESIG==	"Incumbent"	& place==	"Pacific Grove"	& rank==	2
	replace runagain=1 if LAST==	"GAULT"	& FIRST==	"MICHELLE"	& BALDESIG==	"General Manager"	& place==	"Portola"	& rank==	3
	replace runagain=1 if LAST==	"GONZALEZ"	& FIRST==	"YVETTE"	& BALDESIG==	"Substance Abuse Counselor"	& place==	"Greenfield"	& rank==	4
	replace runagain=1 if LAST==	"JOHNSTON"	& FIRST==	"MICHAEL"	& BALDESIG==	"Attorney"	& place==	"Yuba City Unified"	& rank==	3
	replace runagain=1 if LAST==	"KIGER"	& FIRST==	"TRAVIS"	& BALDESIG==	"City Council Member, City of Fullerton"	& place==	"Fullerton"	& rank==	4
	replace runagain=1 if LAST==	"MARTINEZROACH"	& FIRST==	"PATRICIA"	& BALDESIG==	"Governing Board Member, East Side Union High School District"	& place==	"East Side Union High"	& rank==	3
	replace runagain=1 if LAST==	"NEWTON"	& FIRST==	"PHYLLIS"	& BALDESIG==	"Non-Profit Director"	& place==	"Sacramento"	& rank==	19
	replace runagain=1 if LAST==	"PINSON"	& FIRST==	"HARLEY"	& BALDESIG==	"Petroleum Counsel"	& place==	"Bakersfield"	& rank==	2
	replace runagain=1 if LAST==	"RAJCIC"	& FIRST==	"JOHN"	& BALDESIG==	"Retired Educator/Businessman"	& place==	"Ramona Unified"	& rank==	2
	replace runagain=1 if LAST==	"RAMIREZ"	& FIRST==	"SAM"	& BALDESIG==	"Councilmember"	& place==	"Delano"	& rank==	4
	replace runagain=1 if LAST==	"REID"	& FIRST==	"ROBERTA"	& BALDESIG==	"No Ballot Designation"	& place==	"Fullerton"	& rank==	12
	replace runagain=1 if LAST==	"REYES"	& FIRST==	"RUDY"	& BALDESIG==	"Archaeologist/Scientist/Educator"	& place==	"Santee"	& rank==	2
	replace runagain=1 if LAST==	"RIVAS"	& FIRST==	"ANTONIO"	& BALDESIG==	"School Counselor/Teacher"	& place==	"Pajaro Valley Joint Unified"	& rank==	2
	replace runagain=1 if LAST==	"SANCHEZ"	& FIRST==	"SERGIO"	& BALDESIG==	"Councilmember/District Director"	& place==	"Salinas"	& rank==	2
	replace runagain=1 if LAST==	"SWEENEY"	& FIRST==	"THOMAS"	& BALDESIG==	"Retired College Educator"	& place==	"Alpine County Unified"	& rank==	4
	replace runagain=1 if LAST==	"VANDEBROOKE"	& FIRST==	"TOMI"	& BALDESIG==	"College Board President"	& place==	"Contra Costa Community College"	& rank==	3
	replace runagain=1 if LAST==	"VAZQUEZ"	& FIRST==	"AGAPITO"	& BALDESIG==	"City Council Member"	& place==	"Greenfield"	& rank==	3
	replace runagain=1 if LAST==	"WAAGE"	& FIRST==	"EDWARD"	& BALDESIG==	"Incumbent"	& place==	"Pismo Beach"	& rank==	1
	replace runagain=1 if LAST==	"WESTFALL"	& FIRST==	"DONNA"	& BALDESIG==	"Incumbent"	& place==	"Crescent City"	& rank==	5
	replace runagain=1 if LAST==	"WRIGHT"	& FIRST==	"JERMAINE"	& BALDESIG==	"Small Business Owner"	& place==	"Adelanto Elementary"	& rank==	1
		
}			

if $year==2013 {
	replace runagain=1 if LAST==	"DIELS"	& FIRST==	"STEVEN"	& place2013==	"Redondo Beach" & term2013=="Short"
	replace runagain=1 if LAST==	"ZURITA"	& FIRST==	"SATRA"	& place2013==	"Compton Unified"
}

if $year==2014 {
	replace runagain = 1 if  LAST==	"ALCALA"	& FIRST==	"NORMA"	& BALDESIG==	"Parent/Education Director"	& place==	"Washington Unified"
	replace runagain = 1 if  LAST==	"AMARAL"	& FIRST==	"CHRIS"	& BALDESIG==	"Businessman"	& place==	"El Dorado"
	replace runagain = 1 if  LAST==	"AVILA"	& FIRST==	"PAUL"	& BALDESIG==	"Ontario City Councilman"	& place==	"Ontario"
	replace runagain = 1 if  LAST==	"BLAIR"	& FIRST==	"HOLLY"	& BALDESIG==	"Teacher/Professor"	& place==	"Lemoore"
	replace runagain = 1 if  LAST==	"BOWSER"	& FIRST==	"JEFF"	& BALDESIG==	"School Boardmember/Educator"	& place==	"Pleasanton Unified"
	replace runagain = 1 if  LAST==	"BROWN"	& FIRST==	"KEVIN"	& BALDESIG==	"School Board Member"	& place==	"El Dorado Union High"
	replace runagain = 1 if  LAST==	"CLAYPOOL"	& FIRST==	"JESSE"	& BALDESIG==	"Incumbent/Rancher Manager"	& place==	"Janesville Union Elementary"
	replace runagain = 1 if  LAST==	"COCHRANE"	& FIRST==	"ELLEN"	& BALDESIG==	"Public School Teacher"	& place==	"Sacramento City Unified"
	replace runagain = 1 if  LAST==	"DALATI"	& FIRST==	"MICHAEL"	& BALDESIG==	"Tax Instructor/Accountant"	& place==	"Santa Ana Unified"
	replace runagain = 1 if  LAST==	"DAWAR"	& FIRST==	"RAMA"	& BALDESIG==	"Businessman"	& place==	"Central Unified"
	replace runagain = 1 if  LAST==	"DELEHUNT"	& FIRST==	"LINDA"	& BALDESIG==	"Education Administrator"	& place==	"Orinda"
	replace runagain = 1 if  LAST==	"DUTRA"	& FIRST==	"JIMMY"	& BALDESIG==	"Farmer/Business Owner"	& place==	"Watsonville"
	replace runagain = 1 if  LAST==	"LAMPHIER"	& FIRST==	"TERRY"	& BALDESIG==	"Nevada County Supervisor/Businessman"	& place==	"Grass Valley"
	replace runagain = 1 if  LAST==	"LE"	& FIRST==	"VAN"	& BALDESIG==	"Governing Board Member"	& place==	"East Side Union High"
	replace runagain = 1 if  LAST==	"MARTINEZ"	& FIRST==	"FELIPE"	& BALDESIG==	"Retired"	& place==	"Porterville Unified"
	replace runagain = 1 if  LAST==	"MASON"	& FIRST==	"ENSEN"	& BALDESIG==	"CPA/Investment Advisor"	& place==	"Redlands Unified"
	replace runagain = 1 if  LAST==	"MCNEIL"	& FIRST==	"SCOTT"	& BALDESIG==	"Incumbent"	& place==	"El Dorado"
	replace runagain = 1 if  LAST==	"MENDOZA"	& FIRST==	"NATHANIEL"	& BALDESIG==	"Pastor"	& place==	"Dinuba"
	replace runagain = 1 if  LAST==	"OROZCO"	& FIRST==	"MARK"	& BALDESIG==	"Teacher/Business Owner"	& place==	"Beaumont"
	replace runagain = 1 if  LAST==	"PEREZ"	& FIRST==	"MANUEL"	& BALDESIG==	"California State Legislator"	& place==	"Coachella"
	replace runagain = 1 if  LAST==	"PICKARD"	& FIRST==	"LINCOLN"	& BALDESIG==	"Retired Contractor"	& place==	"South Bay Union Elementary"
	replace runagain = 1 if  LAST==	"PINGREY"	& FIRST==	"WINSTON"	& BALDESIG==	"Incumbent"	& place==	"Buckeye Union Elementary"
	replace runagain = 1 if  LAST==	"RHINEHART"	& FIRST==	"KEITH"	& BALDESIG==	"Retired UPS Management/Substitute Teacher"	& place==	"Santa Rosa"
	replace runagain = 1 if  LAST==	"ROCCO"	& FIRST==	"STEVE"	& BALDESIG==	"No Ballot Designation"	& place==	"Orange Unified"
	replace runagain = 1 if  LAST==	"SANDOVAL"	& FIRST==	"JUAN"	& BALDESIG==	"Assistant Superintendent"	& place==	"Kings Canyon Joint Unified"
	replace runagain = 1 if  LAST==	"SNYDER"	& FIRST==	"WILLIAM"	& BALDESIG==	"Incumbent"	& place==	"Merced Union High"
	replace runagain = 1 if  LAST==	"STRICKLAND"	& FIRST==	"GREG"	& BALDESIG==	"Prosecutor/Retired Military"	& place==	"Kings County Office of Education"
	replace runagain = 1 if  LAST==	"SWANSON"	& FIRST==	"ANGELA"	& BALDESIG==	"City Council Member"	& place==	"South Lake Tahoe"
	replace runagain = 1 if  LAST==	"YEP"	& FIRST==	"GARY"	& BALDESIG==	"Mayor/Business Owner"	& place==	"Kerman"
}


